Amazon Redshift
Database Developer Guide

The AWS Documentation website is getting a new look!
Try it now and let us know what you think. Switch to the new look >>

You can return to the original look by selecting English in the language selector above.

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