You are viewing an older version of this section. View current production version.
Join the MemSQL Community Today
Get expert advice, develop skills, and connect with others.

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

memsql> select time('2019-01-01 05:06');
+--------------------------+
| time('2019-01-01 05:06') |
+--------------------------+
| 05:06:00                 |
+--------------------------+