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.
DD-MM-RR
Return Value
DATETIME
Syntax
SYSDATE
Examples
Example 8-126 Displaying the Current Date
The following statement:
SHOW SYSDATE
displays the current date:
08-Sep-00
Scripting on this page enhances content navigation, but does not change the content in any way.