Declaration
TIME(datetime)
Description
Returns the time information of a datetime value as a TIME value.
Examples
obclient> SELECT TIME('2003-12-31 01:02:03');
+-----------------------------+
| TIME('2003-12-31 01:02:03') |
+-----------------------------+
| 01:02:03.000000 |
+-----------------------------+
1 row in set