Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

EXTRACT(TIMEZONE_REGION FROM TO_TIMESTAMP_TZ(01-JAN-2005 19

SQL> SQL> select EXTRACT(TIMEZONE_REGION FROM TO_TIMESTAMP_TZ(   2      '01-JAN-2005 19:15:26 PST', 'DD-MON-YYYY HH24:MI:SS TZR'))   3      AS TZR from dual; TZR ---------------------------------------------------------------- PST