Returns the current time as a TIME value to the nearest second. This function takes no arguments, and the trailing parentheses are optional. SQL statements can refer to SYSTIME anywhere they can refer to a TIME expression.

Syntax

SYSTIME [ ( ) ]

Example

This example illustrates the SYSTIME function, inserting a new row into the objects table, setting the create_time column to the value of the current time:

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

Compatibility

Progress extension