You are viewing an older version of this section. View current production version.
Join the MemSQL Community Today
Get expert advice, develop skills, and connect with others.

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