Mega Code Archive
For DATETIME- or TIMESTAMP-formatted strings, you can use DATE_ADD( ) to introduce a temporal context
<![CDATA[
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)
]]>