Progress
SQL-92
Guide and Reference


SYSDATE Function

Returns the current date as a DATE value. This function takes no arguments, and the trailing parentheses are optional.

SYNTAX

SYSDATE [ ( ) ] 

EXAMPLE

This example illustrates the SYSDATE function, inserting a new row into the objects table, setting the create_date column to the value of the current date:

INSERT INTO objects (object_owner, object_id, create_date)
     VALUES (USER, 1001, SYSDATE) ; 

COMPATIBILITY

Progress Extension


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