Dim Dates
Table Schema
A utility table of common date constructs.
crosschain.dim_dates
| Field | Type | Description |
|---|---|---|
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 | STRING | day of week name for DATE_DAY |
DAY_OF_WEEK_NAME_SHORT | STRING | 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 PRIOR_YEAR_DATE_DAY |
PRIOR_YEAR_WEEK_END_DATE | DATE | date representing the end of the week for PRIOR_YEAR_DATE_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 PRIOR_YEAR_DATE_DAY |
PRIOR_YEAR_ISO_WEEK_END_DATE | DATE | ISO date representing the end of the week for PRIOR_YEAR_DATE_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 PRIOR_YEAR_DATE_DAY |
PRIOR_YEAR_ISO_WEEK_OF_YEAR | NUMBER | number representing the ISO week of the year for PRIOR_YEAR_DATE_DAY |
MONTH_OF_YEAR | NUMBER | number representing the month of the year for DATE_DAY |
MONTH_NAME | STRING | month of year name for DATE_DAY |
MONTH_NAME_SHORT | STRING | 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 PRIOR_YEAR_DATE_DAY |
PRIOR_YEAR_MONTH_END_DATE | DATE | last date of month for PRIOR_YEAR_DATE_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 |
Last updated