Oracle PL/SQL/Date Timezone/TZ OFFSET

Find TZ offset for a given region:

   <source lang="sql">

SQL> SQL> select tz_offset( "us/eastern")

 2  from dual;

TZ_OFFS

---

-04:00 1 row selected. SQL> SQL> --

</source>
   
  

Obtaining Time Zone Offsets

   <source lang="sql">

SQL> --Obtaining Time Zone Offsets SQL> SQL> --TZ_OFFSET() to get the time zone offset hours for PST SQL> SQL> SELECT TZ_OFFSET("PST") FROM dual; TZ_OFFS

---

-07:00 SQL>

      </source>