DATE table - Amazon Redshift
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

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.).