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