VIEW: BIM.BIM_INTL_DATES#

Source

View Text - Preformatted

select TRDATE TRDATE, YEAR YEAR, QTR QTR, MONTH MONTH, QTR_NUM QTR_NUM, MONTH_NUM MONTH_NUM, SECURITY_GROUP_ID SECURITY_GROUP_ID, FISCAL_MONTH FISCAL_MONTH, MONTH_FLAG MONTH_FLAG, FISCAL_QTR FISCAL_QTR, QTR_FLAG QTR_FLAG, FISCAL_YEAR FISCAL_YEAR, YEAR_FLAG YEAR_FLAG, FISCAL_MONTH_START FISCAL_MONTH_START, FISCAL_MONTH_END FISCAL_MONTH_END, FISCAL_QTR_START FISCAL_QTR_START, FISCAL_QTR_END FISCAL_QTR_END, FISCAL_YEAR_START FISCAL_YEAR_START, FISCAL_YEAR_END FISCAL_YEAR_END, FISCAL_ROLL_YEAR_START FISCAL_ROLL_YEAR_START, PRE_FISCAL_MONTH_START PRE_FISCAL_MONTH_START, PRE_FISCAL_MONTH_END PRE_FISCAL_MONTH_END, PRE_FISCAL_QTR_START PRE_FISCAL_QTR_START, PRE_FISCAL_QTR_END PRE_FISCAL_QTR_END, PRE_FISCAL_YEAR_START PRE_FISCAL_YEAR_START, PRE_FISCAL_YEAR_END PRE_FISCAL_YEAR_END, PRE_FISCAL_ROLL_YEAR_START PRE_FISCAL_ROLL_YEAR_START, PRE_FISCAL_ROLL_YEAR_END PRE_FISCAL_ROLL_YEAR_END from "BIM"."BIM_INTL_DATES"

View Text - HTML Formatted

SELECT TRDATE TRDATE
, YEAR YEAR
, QTR QTR
, MONTH MONTH
, QTR_NUM QTR_NUM
, MONTH_NUM MONTH_NUM
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, FISCAL_MONTH FISCAL_MONTH
, MONTH_FLAG MONTH_FLAG
, FISCAL_QTR FISCAL_QTR
, QTR_FLAG QTR_FLAG
, FISCAL_YEAR FISCAL_YEAR
, YEAR_FLAG YEAR_FLAG
, FISCAL_MONTH_START FISCAL_MONTH_START
, FISCAL_MONTH_END FISCAL_MONTH_END
, FISCAL_QTR_START FISCAL_QTR_START
, FISCAL_QTR_END FISCAL_QTR_END
, FISCAL_YEAR_START FISCAL_YEAR_START
, FISCAL_YEAR_END FISCAL_YEAR_END
, FISCAL_ROLL_YEAR_START FISCAL_ROLL_YEAR_START
, PRE_FISCAL_MONTH_START PRE_FISCAL_MONTH_START
, PRE_FISCAL_MONTH_END PRE_FISCAL_MONTH_END
, PRE_FISCAL_QTR_START PRE_FISCAL_QTR_START
, PRE_FISCAL_QTR_END PRE_FISCAL_QTR_END
, PRE_FISCAL_YEAR_START PRE_FISCAL_YEAR_START
, PRE_FISCAL_YEAR_END PRE_FISCAL_YEAR_END
, PRE_FISCAL_ROLL_YEAR_START PRE_FISCAL_ROLL_YEAR_START
, PRE_FISCAL_ROLL_YEAR_END PRE_FISCAL_ROLL_YEAR_END
FROM "BIM"."BIM_INTL_DATES"