VIEW: MTH.MTH_GREGORIAN_CALENDAR#

Source

View Text - Preformatted

select DIMENSION_KEY DIMENSION_KEY, DAY_DESCRIPTION DAY_DESCRIPTION, DAY_NAME DAY_NAME, DAY_START_DATE DAY_START_DATE, DAY DAY, DAY_END_DATE DAY_END_DATE, DAY_OF_CAL_YEAR DAY_OF_CAL_YEAR, DAY_ID DAY_ID, DAY_OF_CAL_WEEK DAY_OF_CAL_WEEK, DAY_OF_CAL_QUARTER DAY_OF_CAL_QUARTER, JULIAN_DATE JULIAN_DATE, DAY_TIME_SPAN DAY_TIME_SPAN, DAY_OF_CAL_MONTH DAY_OF_CAL_MONTH, DAY_DAY_CODE DAY_DAY_CODE, CALENDAR_MONTH_ID CALENDAR_MONTH_ID, MONTH_OF_YEAR MONTH_OF_YEAR, CALENDAR_MONTH_DESCRIPTION CALENDAR_MONTH_DESCRIPTION, CAL_MONTH_NUMBER CAL_MONTH_NUMBER, CALENDAR_MONTH_TIME_SPAN CALENDAR_MONTH_TIME_SPAN, CALENDAR_MONTH_START_DATE CALENDAR_MONTH_START_DATE, CALENDAR_MONTH_CAL_MONTH_CODE CALENDAR_MONTH_CAL_MONTH_CODE, CALENDAR_MONTH_NAME CALENDAR_MONTH_NAME, MONTH_OF_QUARTER MONTH_OF_QUARTER, CALENDAR_MONTH_END_DATE CALENDAR_MONTH_END_DATE, CALENDAR_QUARTER_TIME_SPAN CALENDAR_QUARTER_TIME_SPAN, CALENDAR_QUART_CAL_QUARTER_CO CALENDAR_QUART_CAL_QUARTER_CO, CALENDAR_QUARTER_START_DATE CALENDAR_QUARTER_START_DATE, CALENDAR_QUARTER_END_DATE CALENDAR_QUARTER_END_DATE, CALENDAR_QUARTER_ID CALENDAR_QUARTER_ID, CALENDAR_QUARTER_DESCRIPTION CALENDAR_QUARTER_DESCRIPTION, CAL_QUARTER_NUMBER CAL_QUARTER_NUMBER, CALENDAR_QUARTER_NAME CALENDAR_QUARTER_NAME, QUARTER_OF_YEAR QUARTER_OF_YEAR, CALENDAR_YEAR_END_DATE CALENDAR_YEAR_END_DATE, CALENDAR_YEAR_ID CALENDAR_YEAR_ID, CAL_YEAR_NUMBER CAL_YEAR_NUMBER, CALENDAR_YEAR_NAME CALENDAR_YEAR_NAME, CALENDAR_YEAR_TIME_SPAN CALENDAR_YEAR_TIME_SPAN, CALENDAR_YEAR_CAL_YEAR_CODE CALENDAR_YEAR_CAL_YEAR_CODE, CALENDAR_YEAR_DESCRIPTION CALENDAR_YEAR_DESCRIPTION, CALENDAR_YEAR_START_DATE CALENDAR_YEAR_START_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE from "MTH"."MTH_GREGORIAN_CALENDAR"

View Text - HTML Formatted

SELECT DIMENSION_KEY DIMENSION_KEY
, DAY_DESCRIPTION DAY_DESCRIPTION
, DAY_NAME DAY_NAME
, DAY_START_DATE DAY_START_DATE
, DAY DAY
, DAY_END_DATE DAY_END_DATE
, DAY_OF_CAL_YEAR DAY_OF_CAL_YEAR
, DAY_ID DAY_ID
, DAY_OF_CAL_WEEK DAY_OF_CAL_WEEK
, DAY_OF_CAL_QUARTER DAY_OF_CAL_QUARTER
, JULIAN_DATE JULIAN_DATE
, DAY_TIME_SPAN DAY_TIME_SPAN
, DAY_OF_CAL_MONTH DAY_OF_CAL_MONTH
, DAY_DAY_CODE DAY_DAY_CODE
, CALENDAR_MONTH_ID CALENDAR_MONTH_ID
, MONTH_OF_YEAR MONTH_OF_YEAR
, CALENDAR_MONTH_DESCRIPTION CALENDAR_MONTH_DESCRIPTION
, CAL_MONTH_NUMBER CAL_MONTH_NUMBER
, CALENDAR_MONTH_TIME_SPAN CALENDAR_MONTH_TIME_SPAN
, CALENDAR_MONTH_START_DATE CALENDAR_MONTH_START_DATE
, CALENDAR_MONTH_CAL_MONTH_CODE CALENDAR_MONTH_CAL_MONTH_CODE
, CALENDAR_MONTH_NAME CALENDAR_MONTH_NAME
, MONTH_OF_QUARTER MONTH_OF_QUARTER
, CALENDAR_MONTH_END_DATE CALENDAR_MONTH_END_DATE
, CALENDAR_QUARTER_TIME_SPAN CALENDAR_QUARTER_TIME_SPAN
, CALENDAR_QUART_CAL_QUARTER_CO CALENDAR_QUART_CAL_QUARTER_CO
, CALENDAR_QUARTER_START_DATE CALENDAR_QUARTER_START_DATE
, CALENDAR_QUARTER_END_DATE CALENDAR_QUARTER_END_DATE
, CALENDAR_QUARTER_ID CALENDAR_QUARTER_ID
, CALENDAR_QUARTER_DESCRIPTION CALENDAR_QUARTER_DESCRIPTION
, CAL_QUARTER_NUMBER CAL_QUARTER_NUMBER
, CALENDAR_QUARTER_NAME CALENDAR_QUARTER_NAME
, QUARTER_OF_YEAR QUARTER_OF_YEAR
, CALENDAR_YEAR_END_DATE CALENDAR_YEAR_END_DATE
, CALENDAR_YEAR_ID CALENDAR_YEAR_ID
, CAL_YEAR_NUMBER CAL_YEAR_NUMBER
, CALENDAR_YEAR_NAME CALENDAR_YEAR_NAME
, CALENDAR_YEAR_TIME_SPAN CALENDAR_YEAR_TIME_SPAN
, CALENDAR_YEAR_CAL_YEAR_CODE CALENDAR_YEAR_CAL_YEAR_CODE
, CALENDAR_YEAR_DESCRIPTION CALENDAR_YEAR_DESCRIPTION
, CALENDAR_YEAR_START_DATE CALENDAR_YEAR_START_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM "MTH"."MTH_GREGORIAN_CALENDAR"