SYSDATE
The SYSDATE function returns the current date and time. 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
Example 23-5 Displaying the Current Date
The following statement:
SHOW SYSDATE
displays the current date:
08-Sep-00
