Date Time Functions MySQL Tutorial

mysql>
mysql> select DATE_SUB(curdate(), INTERVAL 1.1 MINUTE_SECOND);
+-------------------------------------------------+
| DATE_SUB(curdate(), INTERVAL 1.1 MINUTE_SECOND) |
+-------------------------------------------------+
| 2007-07-21 23:58:59                             |
+-------------------------------------------------+
1 row in set (0.00 sec)