Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

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

SQL>  SELECT   2    EXTRACT(TIMEZONE_ABBR FROM TO_TIMESTAMP_TZ(   3      '01-JAN-2005 19:15:26 PST', 'DD-MON-YYYY HH24:MI:SS TZR'))   4      AS TZA   5  FROM dual; TZA ---------- PST SQL>