MySQL CURTIME() Function

In MySQL, the CURTIME() function returns the current time of the system in hh:mm:ss or hhmmss format.

The function is exactly the same as the CURRENT_TIME() function.

`CURTIME()` Syntax

Here is the syntax of MySQL CURTIME() function:

CURTIME()

Returns the current time of the system.

SELECT CURTIME(), CURTIME() + 0;

+-----------+---------------+
| CURTIME() | CURTIME() + 0 |
+-----------+---------------+
| 02:04:35  |         20435 |
+-----------+---------------+

Note: The result of CURTIME() + 0 is in the hhmmss format. Because it is a mathematical operation.

CURTIME() + N means adding N seconds to the current time. For example, add 1 second to the current system time:

SELECT CURTIME(), CURTIME() + 1;

+-----------+---------------+
| CURTIME() | CURTIME() + 1 |
+-----------+---------------+
| 02:06:09  |         20610 |
+-----------+---------------+