Mega Code Archive

 

Categories / MySQL Tutorial / Date Time Functions

 

SUBDATE(expr,days)

mysql> mysql> SELECT SUBDATE('1998-01-02 12:00:00', 31); +------------------------------------+ | SUBDATE('1998-01-02 12:00:00', 31) | +------------------------------------+ | 1997-12-02 12:00:00                | +------------------------------------+ 1 row in set (0.00 sec) mysql>