MySQL Server Locale Support +-----------------------+-------------------------+ | DAYNAME(’2010-01-01’) | MONTHNAME(’2010-01-01’) | +-----------------------+-------------------------+ | Friday | January | +-----------------------+-------------------------+ 1 row in set (0.00 sec) mysql>  SELECT DATE_FORMAT(’2010-01-01’,’%W %a %M %b’); +-----------------------------------------+ | DATE_FORMAT(’2010-01-01’,’%W %a %M %b’) | +-----------------------------------------+ | Friday Fri January Jan | +-----------------------------------------+ 1 row in set (0.00 sec) mysql>  SET lc_time_names = ’es_MX’; Query OK, 0 rows affected (0.00 sec) mysql>  SELECT @@lc_time_names; +-----------------+ | @@lc_time_names | +-----------------+ | es_MX | +-----------------+ 1 row in set (0.00 sec) mysql>  SELECT DAYNAME(’2010-01-01’), MONTHNAME(’2010-01-01’); +-----------------------+-------------------------+ | DAYNAME(’2010-01-01’) | MONTHNAME(’2010-01-01’) | +-----------------------+-------------------------+ | viernes | enero | +-----------------------+-------------------------+ 1 row in set (0.00 sec) mysql>  SELECT DATE_FORMAT(’2010-01-01’,’%W %a %M %b’); +-----------------------------------------+ | DATE_FORMAT(’2010-01-01’,’%W %a %M %b’) | +-----------------------------------------+ | viernes vie enero ene | +-----------------------------------------+ 1 row in set (0.00 sec) The day or month name for each of the affected functions is converted from  utf8  to the character set indicated by the  character_set_connection  system variable. lc_time_names  may be set to any of the following locale values. The set of locales supported by MySQL may differ from those supported by your operating system. Locale Value Meaning ar_AE Arabic - United Arab Emirates ar_BH Arabic - Bahrain ar_DZ Arabic - Algeria ar_EG Arabic - Egypt ar_IN Arabic - India ar_IQ Arabic - Iraq ar_JO Arabic - Jordan ar_KW Arabic - Kuwait ar_LB Arabic - Lebanon ar_LY Arabic - Libya 2006