MySQL curtime()函數
CURTIME()
返回當前時間以“HH:MM:SS'或'HHMMSS' 格式的值,具體格式是根據該函數是否用在字符串或數字語境中。該值表示在當前時區。
mysql> SELECT CURTIME(); +---------------------------------------------------------+ | CURTIME() | +---------------------------------------------------------+ | 23:50:26 | +---------------------------------------------------------+ 1 row in set (0.00 sec) mysql> SELECT CURTIME() + 0; +---------------------------------------------------------+ | CURTIME() + 0 | +---------------------------------------------------------+ | 235026 | +---------------------------------------------------------+ 1 row in set (0.00 sec)