Date and Time Functions Specifier Description %v Week ( 01 .. 53 ), where Monday is the first day of the week;  WEEK()  mode 3; used with  %x %W Weekday name ( Sunday .. Saturday ) %w Day of the week ( 0 =Sunday.. 6 =Saturday) %X Year for the week where Sunday is the first day of the week, numeric, four digits; used with  %V %x Year for the week, where Monday is the first day of the week, numeric, four digits; used with  %v %Y Year, numeric, four digits %y Year, numeric (two digits) %% A literal  %  character % x x , for any “ x ”  not listed above 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’ See the description for  DATE_ADD() . DAY()  is a synonym for  DAYOFMONTH() . • DATE_SUB( date ,INTERVAL  expr unit ) • DAY( date ) 2156