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

MySQL TUTORIALS » Date Time Functions » DATE_SUB »

select DATE_SUB(curdate(), INTERVAL '1 1' DAY_HOUR);


mysql>
mysql> select DATE_SUB(curdate(), INTERVAL '1 1' DAY_HOUR);
+----------------------------------------------+
| DATE_SUB(curdate(), INTERVAL '1 1' DAY_HOUR) |
+----------------------------------------------+
| 2007-07-20 23:00:00                          |
+----------------------------------------------+
1 row in set (0.00 sec)

mysql>