DATE table
Column name | Data type | Description |
---|---|---|
DATEID | SMALLINT | Primary key, a unique ID value for each row. Each row represents a day in the calendar year. |
CALDATE | DATE | Calendar date, such as
2008-06-24 .
|
DAY | CHAR(3) | Day of week (short form), such as
SA .
|
WEEK | SMALLINT | Week number, such as
26 .
|
MONTH | CHAR(5) | Month name (short form), such as
JUN .
|
QTR | CHAR(5) | Quarter number (1
through
4 ).
|
YEAR | SMALLINT | Four-digit year
(2008 ).
|
HOLIDAY | BOOLEAN | Flag that denotes whether the day is a public holiday (U.S.). |