Oracle PL/SQL Tutorial/Date Timestamp Functions/LOCALTIMESTAMP
LOCALTIMESTAMP()
SQL>
SQL> Select LOCALTIMESTAMP from dual;
LOCALTIMESTAMP
---------------------------------------------------------------------------
31-MAY-07 08.35.20.343000 PM
SQL>
SQL>
SQL> Select LOCALTIMESTAMP from dual;
LOCALTIMESTAMP
---------------------------------------------------------------------------
31-MAY-07 08.35.20.343000 PM
SQL>