Date Time Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Date Time Functions
  4. SELECT DATE_ADD(1999-01-01, INTERVAL 1 HOUR)
mysql>
mysql> SELECT DATE_ADD('1999-01-01', INTERVAL 1 HOUR);
+-----------------------------------------+
| DATE_ADD('1999-01-01', INTERVAL 1 HOUR) |
+-----------------------------------------+
| 1999-01-01 01:00:00                     |
+-----------------------------------------+
1 row in set (0.00 sec)
mysql>