Mega Code Archive

 

Categories / MySQL / Date Time

 

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>