TIME
Extracts the time part from a datetime object.
Syntax
TIME (dateobj)
Arguments
dateobj: a valid date, datetime, time, or parsable datetime string
Return Type
Time object. If dateobj is not a valid time, returns NULL.
Examples
SELECT TIME('2019-01-01 05:06');
****
+--------------------------+
| TIME('2019-01-01 05:06') |
+--------------------------+
| 05:06:00 |
+--------------------------+