| DATE_DAY | DATE | date for the row |
| PRIOR_DATE_DAY | DATE | date before DATE_DAY |
| NEXT_DATE_DAY | DATE | date after DATE_DAY |
| PRIOR_YEAR_DATE_DAY | DATE | date exactly 1 year before DATE_DAY |
| PRIOR_YEAR_OVER_YEAR_DATE_DAY | DATE | date exactly 1 year after DATE_DAY |
| DAY_OF_WEEK | NUMBER | number representing day of week for DATE_DAY where 1=Sunday |
| DAY_OF_WEEK_ISO | NUMBER | number representing day of week for DATE_DAY where 1=Monday |
| DAY_OF_WEEK_NAME | TEXT | day of week name for DATE_DAY |
| DAY_OF_WEEK_NAME_SHORT | TEXT | day of week abbreviation for DATE_DAY |
| DAY_OF_MONTH | NUMBER | day of month for DATE_DAY |
| DAY_OF_YEAR | NUMBER | day of year for DATE_DAY |
| WEEK_START_DATE | DATE | date representing the start of the week for DATE_DAY |
| WEEK_END_DATE | DATE | date representing the end of the week for DATE_DAY |
| PRIOR_YEAR_WEEK_START_DATE | DATE | date representing the start of the week for PRIORYEARDATE_DAY |
| PRIOR_YEAR_WEEK_END_DATE | DATE | date representing the end of the week for PRIORYEARDATE_DAY |
| WEEK_OF_YEAR | NUMBER | number representing the week of the year for DATE_DAY |
| ISO_WEEK_START_DATE | DATE | ISO date representing the start of the week for DATE_DAY |
| ISO_WEEK_END_DATE | DATE | ISO date representing the end of the week for DATE_DAY |
| PRIOR_YEAR_ISO_WEEK_START_DATE | DATE | ISO date representing the start of the week for PRIORYEARDATE_DAY |
| PRIOR_YEAR_ISO_WEEK_END_DATE | DATE | ISO date representing the end of the week for PRIORYEARDATE_DAY |
| ISO_WEEK_OF_YEAR | NUMBER | number representing the ISO week of the year for DATE_DAY |
| PRIOR_YEAR_WEEK_OF_YEAR | NUMBER | number representing the week of the year for PRIORYEARDATE_DAY |
| PRIOR_YEAR_ISO_WEEK_OF_YEAR | NUMBER | number representing the ISO week of the year for PRIORYEARDATE_DAY |
| MONTH_OF_YEAR | NUMBER | number representing the month of the year for DATE_DAY |
| MONTH_NAME | TEXT | month of year name for DATE_DAY |
| MONTH_NAME_SHORT | TEXT | month of year abbreviation for DATE_DAY |
| MONTH_START_DATE | DATE | first date of month for DATE_DAY |
| MONTH_END_DATE | DATE | last date of month for DATE_DAY |
| PRIOR_YEAR_MONTH_START_DATE | DATE | first date of month for PRIORYEARDATE_DAY |
| PRIOR_YEAR_MONTH_END_DATE | DATE | last date of month for PRIORYEARDATE_DAY |
| QUARTER_OF_YEAR | NUMBER | number representing quarter for DATE_DAY |
| QUARTER_START_DATE | DATE | first date of quarter for DATE_DAY |
| QUARTER_END_DATE | DATE | last date of quarter for DATE_DAY |
| YEAR_NUMBER | NUMBER | number presenting the year for DATE_DAY |
| YEAR_START_DATE | DATE | first date of year for DATE_DAY |
| YEAR_END_DATE | DATE | last date of year for DATE_DAY |
