Mega Code Archive

 

Categories / MySQL Tutorial / Date Time Functions

 

SELECT TIME(2003-12-31 01

mysql> mysql> SELECT TIME('2003-12-31 01:02:03.000123'); +------------------------------------+ | TIME('2003-12-31 01:02:03.000123') | +------------------------------------+ | 01:02:03.000123                    | +------------------------------------+ 1 row in set (0.00 sec) mysql>