4.9.2.82 SYSDATE function (extension)

Syntax

SYSDATE [ ( ) ]

Description

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

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

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