Date Timestamp Functions Oracle PLSQL Tutorial

SQL>  SELECT SYSDATE  from DUAL;
SYSDATE
---------
02-JUN-07
SQL>