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.

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

SingleStore supports TIME type only with precision 0 and 6.

Examples

The following functions return the time in HH:MM:SS format.

SQL

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).

SQL

SELECT CURRENT_TIME(6) +0, CURTIME(6) +0;

+-------------------------------------------------------------+
| CURRENT_TIME(6) +0           | CURTIME(6) +0                |
+-------------------------------------------------------------+
| 24429.844451                 | 24429.844451                 |
+-------------------------------------------------------------+

Related Topics