Obtaining Time Zone Offsets using the TZ_OFFSET() function : TZ_OFFSET « Date Timestamp Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Date Timestamp Functions
  3. TZ_OFFSET
SQL>
SQL> SELECT TZ_OFFSET('PST') FROM dual;

TZ_OFFS
-------
-07:00

SQL>
SQL>








13.25.TZ_OFFSET
13.25.1.Obtaining Time Zone Offsets using the TZ_OFFSET() function