content_image/661719.jpg content_image/661721.jpg content_image/661725.jpg content_image/661727.jpg content_image/661730.jpg
<img src='content_image/661719.jpg'>

mysql> SELECT DATE_FORMAT(’2010-01-01’,’%W %a %M %b’); 

<img src='content_image/661721.jpg'>

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’); 

<img src='content_image/661725.jpg'>

mysql> SELECT DATE_FORMAT(’2010-01-01’,’%W %a %M %b’); 

<img src='content_image/661727.jpg'>

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. 

<img src='content_image/661730.jpg'>

