Obtaining Time Zone Offsets : TZ_OFFSET « Date Timezone « Oracle PL / SQL

1. Oracle PL / SQL
2. Date Timezone
3. TZ_OFFSET

Obtaining Time Zone Offsets

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>

           
       

Related examples in the same category