Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

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> --