Get all the available time zones from oracle database

By Santhosh N

This explains how to get all the time zones available in oracle database.

There is a table with the name, V$TIMEZONE_NAMES which contains the time zones along with the abbreviation.

QUERY: SELECT * FROM V$TIMEZONE_NAMES;

This returns all the time zone names and abbreviations which are available in the oracle

TZNAME          TZABBREV
Africa/Casablanca WET
Africa/Casablanca WEST
Africa/Casablanca CET

Related FAQs

This explains how to truncate the date to the nearest year, month, date, etc...
This explains how to get the offset value of the specified time zone in oracle.
This explains how to get the next weekday name’s date from the specified date.
This explains how to convert the date and time from one time zone to other and return the equivalent time to desired time zone.
This explains the difference between two oracle date functions namely LOCALTIMESTAMP and CURRENT_TIMESTAMP.
This explains how to get the current date and time in the time zone of the current SQL session which is set by the Alter session command.
Get all the available time zones from oracle database  (1432 Views)