Previous
Previous
 
Next
Next


SYSDATE

The SYSDATE function returns the current date and time as a DATETIME value. The format of the date is controlled by the NLS_DATE_FORMAT option. The default DATETIME format (DD-MM-RR) does not display the time.

Return Value

DATETIME

Syntax

SYSDATE

Examples

Displaying the Current Date

The following statement:

SHOW SYSDATE

displays the current date:

08-Sep-00