DBA Data[Home] [Help]

VIEW: AR.HZ_TIMEZONES#

Source

View Text - Preformatted

select TIMEZONE_ID TIMEZONE_ID, GLOBAL_TIMEZONE_NAME GLOBAL_TIMEZONE_NAME, GMT_DEVIATION_HOURS GMT_DEVIATION_HOURS, DAYLIGHT_SAVINGS_TIME_FLAG DAYLIGHT_SAVINGS_TIME_FLAG, BEGIN_DST_MONTH BEGIN_DST_MONTH, BEGIN_DST_DAY BEGIN_DST_DAY, BEGIN_DST_WEEK_OF_MONTH BEGIN_DST_WEEK_OF_MONTH, BEGIN_DST_DAY_OF_WEEK BEGIN_DST_DAY_OF_WEEK, BEGIN_DST_HOUR BEGIN_DST_HOUR, END_DST_MONTH END_DST_MONTH, END_DST_DAY END_DST_DAY, END_DST_WEEK_OF_MONTH END_DST_WEEK_OF_MONTH, END_DST_DAY_OF_WEEK END_DST_DAY_OF_WEEK, END_DST_HOUR END_DST_HOUR, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, STANDARD_TIME_SHORT_CODE STANDARD_TIME_SHORT_CODE, DAYLIGHT_SAVINGS_SHORT_CODE DAYLIGHT_SAVINGS_SHORT_CODE, PRIMARY_ZONE_FLAG PRIMARY_ZONE_FLAG from "AR"."HZ_TIMEZONES"
View Text - HTML Formatted

SELECT TIMEZONE_ID TIMEZONE_ID
, GLOBAL_TIMEZONE_NAME GLOBAL_TIMEZONE_NAME
, GMT_DEVIATION_HOURS GMT_DEVIATION_HOURS
, DAYLIGHT_SAVINGS_TIME_FLAG DAYLIGHT_SAVINGS_TIME_FLAG
, BEGIN_DST_MONTH BEGIN_DST_MONTH
, BEGIN_DST_DAY BEGIN_DST_DAY
, BEGIN_DST_WEEK_OF_MONTH BEGIN_DST_WEEK_OF_MONTH
, BEGIN_DST_DAY_OF_WEEK BEGIN_DST_DAY_OF_WEEK
, BEGIN_DST_HOUR BEGIN_DST_HOUR
, END_DST_MONTH END_DST_MONTH
, END_DST_DAY END_DST_DAY
, END_DST_WEEK_OF_MONTH END_DST_WEEK_OF_MONTH
, END_DST_DAY_OF_WEEK END_DST_DAY_OF_WEEK
, END_DST_HOUR END_DST_HOUR
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, STANDARD_TIME_SHORT_CODE STANDARD_TIME_SHORT_CODE
, DAYLIGHT_SAVINGS_SHORT_CODE DAYLIGHT_SAVINGS_SHORT_CODE
, PRIMARY_ZONE_FLAG PRIMARY_ZONE_FLAG
FROM "AR"."HZ_TIMEZONES"