Sysdate

SYSDATE returns the current date in the database server's operating system. The following example gets the current date:

SQL> SELECT SYSDATE
  2  FROM dual;

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

SQL>