Date Timezone Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Date Timezone
  4. 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> --