TIME
On this page
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.
Examples
SELECT TIME('2019-01-01 05:06');
+--------------------------+
| TIME('2019-01-01 05:06') |
+--------------------------+
| 05:06:00 |
+--------------------------+Last modified: May 31, 2023