Using CURTIME() function : CURTIME « Date Time Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Date Time Functions
  3. CURTIME
mysql>
mysql> select CURTIME();
+-----------+
| CURTIME() |
+-----------+
| 13:54:27  |
+-----------+
1 row in set (0.00 sec)








14.7.CURTIME
14.7.1.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
14.7.2.Using CURTIME() function