Use the EXTRACT function. You cannot specify an EXTRACT function in the definition of a column-partitioned join index. Join index definitions support only the extraction of years and months from a date column.
- YEAR
- Extract a year from a date column.
- MONTH
- Extract a month from a date column.
- date_expression
- Date column or date expression from which to derive the year or month.