Important

New database features are no longer connected to engine versions; features are now enabled independently during scheduled update windows, and “major” and “minor” releases no longer exist in Helios. Please visit the release notes to view the latest features available in your database clusters.

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.

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 Helios 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