All pages
Powered by GitBook
1 of 1

Loading...

CURTIME

Return the current time. This function outputs the current time of day as a value in 'HH:MM:SS' or HHMMSS format.

Syntax

CURTIME([precision])

Description

Returns the current time as a value in HH:MM:SS or HHMMSS.uuuuuu format, depending on whether the function is used in a string or numeric context. The value is expressed in the current .

The optional precision determines the microsecond precision. See .

Examples

With precision:

See Also

This page is licensed: GPLv2, originally from

time zone
Microseconds in MariaDB
Microseconds in MariaDB
fill_help_tables.sql
SELECT CURTIME();
+-----------+
| CURTIME() |
+-----------+
| 12:45:39  |
+-----------+

SELECT CURTIME() + 0;
+---------------+
| CURTIME() + 0 |
+---------------+
| 124545.000000 |
+---------------+
SELECT CURTIME(2);
+-------------+
| CURTIME(2)  |
+-------------+
| 09:49:08.09 |
+-------------+