Release 10.1A: OpenEdge Data Management:
SQL Reference

> ## CURDATE

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

> #### Syntax

>     CURDATE ( )

> Example

> The following example shows how to use the `CURDATE` function:

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

> #### Note

> - SQL statements can refer to `CURDATE` anywhere they can refer to a `DATE` expression.

> ##### Compatibility

> ODBC compatible

> #### See also

> SYSDATE function

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