Oracle Date/Time Function - Oracle/PLSQL SYSDATE Function






This Oracle tutorial explains how to use the Oracle/PLSQL SYSDATE function.

The Oracle/PLSQL SYSDATE function returns the current system date and time.

SYSDATE returns the current date in the database server's operating system.

Syntax

The syntax for the Oracle/PLSQL SYSDATE function is:

SYSDATE

There are no parameters or arguments for the SYSDATE function.

Example

The following example gets the current date:


SQL> SELECT SYSDATE
  2  FROM dual;

SYSDATE
---------
14-JUL-11

SQL>