Date and Time Functions -> ’2024-12-30 22:58:59’ mysql>  SELECT DATE_ADD(’1900-01-01 00:00:00’, -> INTERVAL ’-1 10’ DAY_HOUR); -> ’1899-12-30 14:00:00’ mysql>  SELECT DATE_SUB(’1998-01-02’, INTERVAL 31 DAY); -> ’1997-12-02’ mysql>  SELECT DATE_ADD(’1992-12-31 23:59:59.000002’, -> INTERVAL ’1.999999’ SECOND_MICROSECOND); -> ’1993-01-01 00:00:01.000001’ The specifiers shown in the following table may be used in the  format  string. The  %  character is required before format specifier characters. The specifiers apply to other functions as well: STR_TO_DATE() ,  TIME_FORMAT() ,  UNIX_TIMESTAMP() . Formats the  date  value according to the  format  string. • DATE_FORMAT( date , format ) Specifier Description %a Abbreviated weekday name ( Sun .. Sat ) %b Abbreviated month name ( Jan .. Dec ) %c Month, numeric ( 0 .. 12 ) %D Day of the month with English suffix ( 0th ,  1st , 2nd ,  3rd , …) %d Day of the month, numeric ( 00 .. 31 ) %e Day of the month, numeric ( 0 .. 31 ) %f Microseconds ( 000000 .. 999999 ) %H Hour ( 00 .. 23 ) %h Hour ( 01 .. 12 ) %I Hour ( 01 .. 12 ) %i Minutes, numeric ( 00 .. 59 ) %j Day of year ( 001 .. 366 ) %k Hour ( 0 .. 23 ) %l Hour ( 1 .. 12 ) %M Month name ( January .. December ) %m Month, numeric ( 00 .. 12 ) %p AM  or  PM %r Time, 12-hour ( hh:mm:ss  followed by  AM  or  PM ) %S Seconds ( 00 .. 59 ) %s Seconds ( 00 .. 59 ) %T Time, 24-hour ( hh:mm:ss ) %U Week ( 00 .. 53 ), where Sunday is the first day of the week;  WEEK()  mode 0 %u Week ( 00 .. 53 ), where Monday is the first day of the week;  WEEK()  mode 1 %V Week ( 01 .. 53 ), where Sunday is the first day of the week;  WEEK()  mode 2; used with  %X 2155