SQL 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)