Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

Obtaining Time Zone Offsets using the TZ_OFFSET() function

SQL> SQL> SELECT TZ_OFFSET('PST') FROM dual; TZ_OFFS ------- -07:00 SQL>