APPX Software Library

Chapter 4: SQL Language Elements

4.9.2.20 CURDATE function (ODBC compatible)

Syntax

CURDATE ()

Description

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

SQL statements can refer to CURDATE anywhere they can refer to a DATE expression. For example,

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