MySQL CURRENT_TIME() Function

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

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

CURRENT_TIME() Syntax

Here is the syntax of MySQL CURRENT_TIME() function:

CURRENT_TIME()

CURRENT_TIME() Examples

Returns the current time of the system.

SELECT 
    CURRENT_TIME,
    CURRENT_TIME(),
    CURRENT_TIME() + 0;

+--------------+----------------+--------------------+
| CURRENT_TIME | CURRENT_TIME() | CURRENT_TIME() + 0 |
+--------------+----------------+--------------------+
| 02:11:03     | 02:11:03       |              21103 |
+--------------+----------------+--------------------+

Note: The result of CURRENT_TIME() + 0 is in the hhmmss format.

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

SELECT CURRENT_TIME(), CURRENT_TIME() + 1;

+----------------+--------------------+
| CURRENT_TIME() | CURRENT_TIME() + 1 |
+----------------+--------------------+
| 02:09:39       |              20940 |
+----------------+--------------------+