CURRENT_ TIME And CURTIME
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
Returns the current time of day.
Syntax
CURRENT_TIME()
CURTIME()
CURRENT_TIME(n)
CURTIME(n)
Return Type
Time object.
Arguments
-
n: specifies fractional seconds precision in the returned TIME value
Remarks
CURRENT_
and CURTIME
functions are synonyms to each other.HH:MM:SS
or HHMMSS
format.
Fractional Seconds Precision
SingleStore supports TIME type only with precision 0
and 6
.
Examples
The following functions return the time in HH:MM:SS
format.
SELECT CURRENT_TIME(), CURTIME();
+-------------------------------------------------------------+
| CURRENT_TIME() | CURTIME() |
+-------------------------------------------------------------+
| 02:42:20 | 02:42:20 |
+-------------------------------------------------------------+
The following functions return the current time in HHMMSS.
format (with fractional seconds precision).
SELECT CURRENT_TIME(6) +0, CURTIME(6) +0;
+-------------------------------------------------------------+
| CURRENT_TIME(6) +0 | CURTIME(6) +0 |
+-------------------------------------------------------------+
| 24429.844451 | 24429.844451 |
+-------------------------------------------------------------+
Related Topics
Last modified: May 31, 2023