LOCALTIMESTAMP() : LOCALTIMESTAMP « Date Timestamp Functions « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Date Timestamp Functions
3. LOCALTIMESTAMP

SQL>
SQL> Select LOCALTIMESTAMP from dual;

LOCALTIMESTAMP
---------------------------------------------------------------------------
31-MAY-07 08.35.20.343000 PM

SQL>