Date Timezone Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Date Timezone
  4. Get LOCALTIMESTAMP
SQL> --LOCALTIMESTAMP()
SQL>
SQL> SELECT  LOCALTIMESTAMP FROM dual;
LOCALTIMESTAMP
---------------------------------------------------------------------------
16-SEP-06 08.35.05.062000 PM
SQL>