content_image/689745.jpg
-> ’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’ 

• DATE_FORMAT( date , format ) 

Formats the date  value according to the format  string. 

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() . 

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

