SET @@lc_time_names = 'fr_FR'; SELECT DAYNAME('2000-01-01') dayname; +---------+ | dayname | +---------+ | samedi | +---------+