The function CURTIME returns the current time. The precision is one second.
SQL Syntax:
|
|
CURTIME() |
Escape Syntax:
|
|
{fn CURTIME()} |
Return Type:
|
|
TIME |
|
|
|
Examples:
SELECT curtime()
SELECT {fn curtime()}, * FROM mytable
SELECT * FROM mytable WHERE start < curtime()
CREATE TABLE abc(
name varchar(30),
start time default curtime()
)
see also:
SQL Date Time Functions
NOW
CURDATE
|