Date Timestamp Functions Oracle PLSQL Tutorial

SQL>
SQL> Select LOCALTIMESTAMP from dual;
LOCALTIMESTAMP
---------------------------------------------------------------------------
31-MAY-07 08.35.20.343000 PM
SQL>