Find TZ offset for a given region: : TZ_OFFSET « Date Timezone « Oracle PL / SQL

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

Find TZ offset for a given region:

 
SQL>
SQL> select tz_offset( 'us/eastern')
  2  from dual;
TZ_OFFS
-------
-04:00

1 row selected.

SQL>
SQL> --

 

Related examples in the same category