Date part extraction units. Used to extract specific components from dates for grouping. Values: YEAR: Extract year (2024) MONTH: Extract month (1-12) WEEK: Extract week of year (1-53) DAY: Extract day of month (1-31) DAY_OF_WEEK: Extract day of week (1=Sunday, 7=Saturday) DAY_OF_YEAR: Extract day of year (1-366) HOUR: Extract hour (0-23) MINUTE: Extract minute (0-59) SECOND: Extract second (0-59) Examples: - Use DAY_OF_WEEK to analyze weekly patterns - Use HOUR to find peak usage times
-
YEAR(value:'year') -
MONTH(value:'month') -
WEEK(value:'week') -
DAY(value:'day') -
DAYOFWEEK(value:'dayOfWeek') -
DAYOFYEAR(value:'dayOfYear') -
HOUR(value:'hour') -
MINUTE(value:'minute') -
SECOND(value:'second')