Date Time MySQL

  1. Home
  2. MySQL
  3. Date Time
  4. For DATETIME- or TIMESTAMP-formatted strings, you can use DATE_ADD( ) to introduce a temporal context
mysql>
mysql> SELECT DATE_ADD('1999-01-01 12:30:45',INTERVAL 0 DAY)+0 AS 'numeric datetime', DATE_ADD('19990101123045',INTERVAL
 0 DAY)+0 AS 'numeric timestamp';
+------------------+-------------------+
| numeric datetime | numeric timestamp |
+------------------+-------------------+
|   19990101123045 |    19990101123045 |
+------------------+-------------------+
1 row in set (0.00 sec)