CURRENT_TIME And CURTIME

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

On this page