SYSDATE

SYSDATE returns the current date and time of the operating system on which the database resides. The format of the value depends on the value of the NLS_DATE_FORMAT initialization parameter.

Return Value

DATE

Syntax

SYSDATE

Examples

SYSDATE returns a value such as 13-AUG-06 with NLS_DATE_FORMAT set to DD-MON-RR.

TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS') returns a value such as 08-13-2006 17:20:47. The date format provided in the call to TO_CHAR displays both the date and the time.