MySQL in a Nutshell

Name

TIME( )

Synopsis

TIME(time)

This function returns the time from a given string or column containing date and time data. This function is available as of Version 4.1.1 of MySQL.

SELECT TIME(NOW( )) , NOW( );
+-------------+---------------------+
| TIME(NOW( )) | NOW( )                |
+-------------+---------------------+
| 21:14:20    | 2005-01-11 21:14:20 |
+-------------+---------------------+