Progress
SQL-92
Guide and Reference


SYSTIME Function

Returns the current time as a TIME value to the nearest second. This function takes no arguments, and the trailing parentheses are optional.

NOTE: 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


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095