CURRENT_TIME And CURTIME
Returns the current time of day.
Syntax
CURRENT_TIME() CURTIME() CURRENT_TIME(n) CURTIME(n)
Return Type
Time object. The time zone will be in UTC unless the time zone has been converted. See Setting the Time Zone for more information.
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
SingleStoreDB 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