MSC_TIME_GREGORIAN_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
CALENDAR_TYPE CALENDAR_CODE SEQ_NUM YEAR YEAR_START_DATE YEAR_END_DATE QUARTER QUARTER_START_DATE QUARTER_END_DATE MONTH MONTH_START_DATE MONTH_END_DATE WEEK WEEK_START_DATE WEEK_END_DATE DAY WORKING_DAY

Query

SQL_Statement

SELECT DISTINCT mc.calendar_type as CALENDAR_TYPE, mc.calendar_code as CALENDAR_CODE, NULL as SEQ_NUM, concat('Year: ',mcm.year_start_date) AS YEAR, mcm.year_start_date as YEAR_START_DATE, mcm.year_end_date as YEAR_END_DATE, concat('Quarter: ',mcm.quarter_start_date) AS QUARTER, mcm.quarter_start_date as QUARTER_START_DATE, mcm.quarter_end_date as QUARTER_END_DATE, concat('Month: ',mcm.month_start_date) AS MONTH, mcm.month_start_date as MONTH_START_DATE, mcm.month_end_date as MONTH_END_DATE, NULL as WEEK, NULL as WEEK_START_DATE, NULL as WEEK_END_DATE, to_date(to_char(mcaldat.CALENDAR_DATE,'DD-MON-YYYY'),'DD-MON-YYYY' ) AS DAY, NULL as WORKING_DAY FROM MSC_CALENDARS mc, MSC_CALENDAR_MONTHS mcm, MSC_CALENDAR_DATES mcaldat WHERE (mcaldat.calendar_date BETWEEN mcm.month_start_date AND mcm.month_end_date) AND (mcm.month_start_date between mc.calendar_start_date and mc.calendar_end_date) AND mcaldat.calendar_code=mcm.calendar_code AND mcm.calendar_code=mc.calendar_code AND mc.calendar_type=1