Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| day_date | timestamp |
|
|
The date generated by the series, e.g.: 2016-08-01 |
| day_of_week | numeric |
|
|
Numeric representation of the day of the week extracted from the date, e.g.: 1 |
| day_name | text |
|
|
Name of the day of the week, e.g.: Monday |
| is_weekday | bool |
|
|
Whether the day is a weekday or not, e.g.: True or False |
| is_weekend | bool |
|
|
Whether the day is a weekend or not, e.g.: True or False |
| day_of_year | numeric |
|
|
Day of the year extracted from the date, e.g.: 125 |
| day_of_month | numeric |
|
|
Day of the month extracted from the date, e.g.: 5 |
| days_to_month_end | int8 |
|
|
The number of days to the end of the month, e.g.: 3 |
| week_of_year | numeric |
|
|
Week of the year extracted from the date, e.g.: 18 |
| month_of_year | numeric |
|
|
Month of the year extracted from the date, e.g.: 5 |
| quarter_of_year | numeric |
|
|
Quarter of the year extracted from the date, e.g.: 2 |
| year | numeric |
|
|
Year extracted from the date, e.g.: 2016 |
| start_of_month | timestamp |
|
|
The start date of the month, e.g.: 2016-08-01 |
| start_of_week | timestamp |
|
|
The start date of the week, e.g.: 2016-08-01 |
| month_and_year | text |
|
|
Formatted month and year, e.g.: Aug 2016 |