SYSDATE

The Oracle and PL/SQL SYSDATE function returns the current system date and time on your database.

The general format is:

SYSDATE

Example 1:

SELECT SYSDATE FROM DUAL;

returns:

SYSDATE
---------
15-JUN-14

Example 2:

SELECT TO_CHAR(SYSDATE,'DD/MM/YYYY HH24:MI:SS') FROM DUAL;

returns:

SYSDATE
---------
15/06/2015 13:08:59