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                 |
+--------------------------+

Last modified: May 31, 2023

Was this article helpful?