Date Time MySQL

  1. Home
  2. MySQL
  3. Date Time
  4. Some interval specifiers comprise both date and time parts
mysql>
mysql> SELECT NOW( ), DATE_ADD(NOW( ),INTERVAL '14:30' HOUR_MINUTE);
+---------------------+-----------------------------------------------+
| NOW( )              | DATE_ADD(NOW( ),INTERVAL '14:30' HOUR_MINUTE) |
+---------------------+-----------------------------------------------+
| 2011-10-03 13:05:47 | 2011-10-04 03:35:47                           |
+---------------------+-----------------------------------------------+
1 row in set (0.00 sec)
mysql>