Mega Code Archive

 

Categories / MySQL Tutorial / Date Time Functions

 

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