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

Ranges for the month and day specifiers begin with zero due to the fact that MySQL permits the storing of incomplete dates such as ’2014-00-00’ . 

The language used for day and month names and abbreviations is controlled by the value of the lc_time_names  system variable (Section 10.16, “MySQL Server Locale Support” ). 

For the %U , %u , %V , and %v  specifiers, see the description of the WEEK()  function for information about the mode values. The mode affects how week numbering occurs. 

DATE_FORMAT()  returns a string with a character set and collation given by character_set_connection  and collation_connection  so that it can return month and weekday names containing non-ASCII characters. 

mysql> SELECT DATE_FORMAT(’2009-10-04 22:23:00’, ’%W %M %Y’); -> ’Sunday October 2009’ mysql> SELECT DATE_FORMAT(’2007-10-04 22:23:00’, ’%H:%i:%s’); -> ’22:23:00’ mysql> SELECT DATE_FORMAT(’1900-10-04 22:23:00’, -> ’%D %y %a %d %m %b %j’); -> ’4th 00 Thu 04 10 Oct 277’ mysql> SELECT DATE_FORMAT(’1997-10-04 22:23:00’, -> ’%H %k %I %r %T %S %w’); -> ’22 22 10 10:23:00 PM 22:23:00 00 6’ mysql> SELECT DATE_FORMAT(’1999-01-01’, ’%X %V’); -> ’1998 52’ mysql> SELECT DATE_FORMAT(’2006-06-00’, ’%d’); -> ’00’ 

• DATE_SUB( date ,INTERVAL expr unit ) 

See the description for DATE_ADD() . 

• DAY( date ) 

DAY()  is a synonym for DAYOFMONTH() . 

