My Oracle Support Banner

Is There Any Table/View That Can Be Used To Query Time Zone Description In A Report ? (Doc ID 823653.1)

Last updated on DECEMBER 22, 2016

Applies to:

Oracle iLearning - Version 5.0 and later
Information in this document applies to any platform.


We need to include the time zone description associated with an offering in a report. Only a time zone numeric value is available in the view.  The view, VR_OFFERING, contains the column, TIMEZONE, associated with the start/end dates of the offering but it is a number value.

We need the timezone description as it is displayed on the OFFERING PROPERTIES page in the Administrator interface.
For example, the time zone numeric value of "7" is described as "Eastern Time: EST (UTC/GMT -5 hours)" on this page.

Is there a table or view we can reference to look up the time zone description to pull into the report from the time zone numeric value?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.