select DATE_SUB(curdate(), INTERVAL '1 : DATE_SUB : Date Time Functions MySQL TUTORIALS

MySQL TUTORIALS » Date Time Functions » DATE_SUB »

select DATE_SUB(curdate(), INTERVAL '1


mysql>
mysql> select DATE_SUB(curdate(), INTERVAL '1:1' HOUR_MINUTE);
+-------------------------------------------------+
| DATE_SUB(curdate(), INTERVAL '1:1' HOUR_MINUTE) |
+-------------------------------------------------+
| 2007-07-21 22:59:00                             |
+-------------------------------------------------+
1 row in set (0.00 sec)

mysql>