On this page
Kater SQL Functions Date parts
Date parts
A date part gives one part of a date as a number or a name, such as the day of the week.
Use one to compare the same part across periods, such as each weekday. See Dates.
| Function | What it does |
|---|---|
KATER__DAY_OF_WEEK | The day’s short name, such as Mon. |
KATER__DAY_OF_WEEK_INDEX | The day’s number in its week, from 0 for Sunday to 6 for Saturday. |
KATER__DAY_OF_MONTH | The day of its month, from 1 to 31. |
KATER__DAY_OF_QUARTER | The day of its quarter, counted from 1. |
KATER__DAY_OF_YEAR | The day of its year, from 1 to 366. |
KATER__WEEK_OF_YEAR | The ISO week of its year, from 1 to 53. |
KATER__MONTH_NUM | The month’s number, from 1 to 12. |
KATER__MONTH_NAME | The month’s short name, such as Jan. |
KATER__QUARTER_OF_YEAR | The quarter’s number, from 1 to 4. |
KATER__HOUR_OF_DAY | The hour of its day, from 0 to 23. |
KATER__MINUTE_OF_HOUR | The minute of its hour, from 0 to 59. |