w3resource

Oracle SYSDATE function

Description

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

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

Pictorial Presentation of Oracle SYSDATE function

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



Share this Tutorial / Exercise on : Facebook and Twitter