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