CURTIME() returns the current time as a value in 'HH:MM:SS' or HHMMSS format, depending on whether the function is used in a string or numeric context : CURTIME « Date Time Functions « MySQL Tutorial

1. MySQL Tutorial
2. Date Time Functions
3. CURTIME

CURRENT_TIME and CURRENT_TIME() are synonyms for CURTIME().

mysql>d
mysql> SELECT CURTIME();
+-----------+
| CURTIME() |
+-----------+
| 19:46:02  |
+-----------+
1 row in set (0.00 sec)

mysql>
mysql> SELECT CURTIME() + 0;
+---------------+
| CURTIME() + 0 |
+---------------+
| 194602.000000 |
+---------------+
1 row in set (0.00 sec)

mysql>
mysql>
mysql> select CURRENT_TIME();
+----------------+
| CURRENT_TIME() |
+----------------+
| 19:46:02       |
+----------------+
1 row in set (0.00 sec)

mysql>
mysql>
mysql>
mysql>