Oracle SYSDATE function

Last update on September 21 2024 11:11:46 (UTC/GMT +8 hours)

Description

The SYSDATE function is used to retrieve the current date and time set for the operating system on which the database resides.

Retrieving Current Date and Time: Get the current date and time from the database server’s operating system.

Timestamping Records: Use the current date and time to timestamp records in database operations.

Calculating Date Differences: Perform date arithmetic by comparing SYSDATE with other date values.

Scheduling Tasks: Assist in scheduling and executing tasks based on the current system time.

Syntax:

SYSDATE

Parameters:
The function requires no parameters.

Applies to:
Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i

Return Value:

This function returns the date and time set for the operating system of your local database.

Pictorial Presentation

Examples: Oracle SYSDATE function

The following statement returns the current operating system date and time :

SQL> SELECT TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS') "NOW"
    2     FROM DUAL;

Sample Output:

 NOW
-------------------
05-01-2015 15:39:45

Previous: SYS_EXTRACT_UTC
Next: SYSTIMESTAMP