Progress
SQL-92
Guide and Reference


CURDATE Function

Returns the current date as a DATE value. This function takes no arguments.

SYNTAX

CURDATE ( ) 

NOTE: SQL statements can refer to CURDATE anywhere they can refer to a DATE expression.

EXAMPLE

The following example shows how to use the CURDATE function:

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

COMPATIBILITY

ODBC Compatible


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