date_dimension
This table contains information about dates.
This table contains information about dates. It is generated from a file containing correct date/time data.
| Column Name | Data Type | NULLs |
date_key |
INTEGER | No |
date |
DATE | Yes |
full_date_description |
VARCHAR(18) | Yes |
day_of_week |
VARCHAR(9) | Yes |
day_number_in_calendar_month |
INTEGER | Yes |
day_number_in_calendar_year |
INTEGER | Yes |
day_number_in_fiscal_month |
INTEGER | Yes |
day_number_in_fiscal_year |
INTEGER | Yes |
last_day_in_week_indicator |
INTEGER | Yes |
last_day_in_month_indicator |
INTEGER | Yes |
calendar_week_number_in_year |
INTEGER | Yes |
calendar_month_name |
VARCHAR(9) | Yes |
calendar_month_number_in_year |
INTEGER | Yes |
calendar_year_month |
CHAR(7) | Yes |
calendar_quarter |
INTEGER | Yes |
calendar_year_quarter |
CHAR(7) | Yes |
calendar_half_year |
INTEGER | Yes |
calendar_year |
INTEGER | Yes |
holiday_indicator |
VARCHAR(10) | Yes |
weekday_indicator |
CHAR(7) | Yes |
selling_season |
VARCHAR(32) | Yes |