Important
The SingleStore 10 release candidate (RC) gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 9.0 is recommended for production workloads, which can later be upgraded to SingleStore 10.
TIME
On this page
The TIME() function 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: