Amazon Redshift
Database Developer Guide

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