Oracle PL/SQL/Date Timezone/LOCALTIMESTAMP
Get LOCALTIMESTAMP
SQL> --LOCALTIMESTAMP()
SQL>
SQL> SELECT LOCALTIMESTAMP FROM dual;
LOCALTIMESTAMP
---------------------------------------------------------------------------
16-SEP-06 08.35.05.062000 PM
SQL>