date_part( units, timestamp )
Extract the given units out of a timestamp. The units value is a string and can be any of the following values:
| "day" | "minute" | "second" | "year" |
| "hour" | "month" | "week" | "dow" |
| "doy" |
where:
- "dow" returns the correct day of the week, for example, 1 for Sunday as the first day of the week, and 7 for Saturday as the last day of the week.
- "doy" returns the Julian day of the year, for example, 1 for the first day of the year, 365 or 366 for the last day of the year.
Example
year = date_part("year", ts )
day = date_part("dow", ts)