Skip Headers
Previous
Previous
 
Next
Next


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.