Date Time Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Date Time Functions
  4. 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>