Mega Code Archive

 

Categories / MySQL Tutorial / Date Time Functions

 

SELECT 1998-01-01 - INTERVAL 1 SECOND

mysql> mysql> SELECT '1998-01-01' - INTERVAL 1 SECOND; +----------------------------------+ | '1998-01-01' - INTERVAL 1 SECOND | +----------------------------------+ | 1997-12-31 23:59:59              | +----------------------------------+ 1 row in set (0.00 sec) mysql>