Flipside Docs
Search…
⌃K

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