CURTIME

 

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


100% pure Java DBMS
Mirror Site