CURTIME() returns the current time as a value in 'HH : CURTIME : Date Time Functions MySQL TUTORIALS

MySQL TUTORIALS » Date Time Functions » CURTIME »

CURTIME() returns the current time as a value in 'HH

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>