Try OpenEdge Now
skip to main content
SQL Reference
SQL Reference : OpenEdge SQL Functions : CURDATE
 

CURDATE

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

Syntax

CURDATE ( )

Notes

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