Date Time MySQL

  1. Home
  2. MySQL
  3. Date Time
  4. Forcing MySQL to Treat Strings as Temporal Values
mysql>
mysql> SELECT SEC_TO_TIME(TIME_TO_SEC('12:30:45'))+0;
+----------------------------------------+
| SEC_TO_TIME(TIME_TO_SEC('12:30:45'))+0 |
+----------------------------------------+
|                          123045.000000 |
+----------------------------------------+
1 row in set (0.00 sec)
mysql>