Returns the current time as a TIME value. This function takes no arguments.

Syntax

CURTIME ( )

Notes

SQL statements can refer to CURTIME anywhere they can refer to a TIME expression.

Example

This example illustrates how to use the CURTIME function to INSERT the current time into the create_time column of the objects table:

INSERT INTO objects (object_owner, object_id, create_time)
     VALUES (USER, 1001, CURTIME()) ;

Compatibility

ODBC compatible