Progress
SQL-92
Guide and Reference


CURTIME Function

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

SYNTAX

CURTIME ( ) 

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


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