Mega Code Archive
Categories
/
Oracle PLSQL
/
Date Timezone
EXTRACT(TIMEZONE_ABBR FROM TO_TIMESTAMP_TZ(01-JAN-2005 19
SQL> SQL> select EXTRACT(TIMEZONE_ABBR FROM TO_TIMESTAMP_TZ( 2 '01-JAN-2005 19:15:26 PST', 'DD-MON-YYYY HH24:MI:SS TZR')) 3 AS TZA from dual; TZA ---------- PST SQL>