TIME

2024-12-02 03:48:26  Updated

Syntax

TIME(datetime)

Purpose

TIME() returns the datetime value of the TIME data type.

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

Contact Us