Outdated Version
You are viewing an older version of this section. View current production version.
CURRENT_TIME And CURTIME
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_TIME and CURTIME functions are synonyms to each other. Both the functions return the current time in either HH:MM:SS or HHMMSS format.
Fractional Seconds Precision
MemSQL 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.uuuuuu 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
