Posted By

bbrumm on 02/28/17

Tagged

sql
Oracle

Versions (?)

Last Edited at 02/28/17 05:44am

Statistics

Viewed 1055 times

Favorited by 0 user(s)

Related snippets

Oracle TZ_OFFSET Function

/ Published in: SQL

A few examples of the TZ_OFFSET function.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

--Example 1
SELECT TZ_OFFSET('US/Eastern') AS tz_test
FROM dual;
 
--Example 2
SELECT TZ_OFFSET('-02:00') AS tz_test
FROM dual;
 
--Example 3
SELECT TZ_OFFSET(SESSIONTIMEZONE) AS tz_test
FROM dual;
 
--Example 4
SELECT TZ_OFFSET(DBTIMEZONE) AS tz_test
FROM dual;
 
--Example 5
SELECT
TZ_OFFSET(SESSIONTIMEZONE) AS tz_test,
SIGN(TO_NUMBER(SUBSTR(TZ_OFFSET(SESSIONTIMEZONE), 1, 3))) * (
  TO_NUMBER(SUBSTR(TZ_OFFSET(SESSIONTIMEZONE), 2, 2)) +
  TO_NUMBER(SUBSTR(TZ_OFFSET(SESSIONTIMEZONE), 5, 2)) / 60
) AS tz_offset_num
FROM dual;
 
 
 
SELECT * FROM V$TIMEZONE_NAMES;