Home > Scripts > How to get the timezone information.

How to get the timezone information.

April 24, 2013

You can get the installed timezone information from below SQL.

 

SELECT tzname, tzabbrev FROM V$TIMEZONE_NAMES;

output is similar to 

For the default time zone file, this statement results in output similar to the following:

TZNAME               TZABBREV
-------------------- ----------
Africa/Algiers       LMT
Africa/Algiers       PMT
Africa/Algiers       WET
Africa/Algiers       WEST
Africa/Algiers       CET
Africa/Algiers       CEST
Africa/Cairo         LMT
Africa/Cairo         EET
Africa/Cairo         EEST
Africa/Casablanca    LMT
Africa/Casablanca    WET
Africa/Casablanca    WEST
Africa/Casablanca    CET
...
W-SU                 LMT
W-SU                 MMT
W-SU                 MST
W-SU                 MDST
W-SU                 S
W-SU                 MSD
W-SU                 MSK
W-SU                 EET
W-SU                 EEST
WET                  LMT
WET                  WEST
WET                  WET

1393 rows selected
Advertisements
Categories: Scripts
%d bloggers like this: