Use the EXTRACT date function. You cannot specify an EXTRACT function in the definition of a column-partitioned join index. See Teradata Vantage™ - SQL Date and Time Functions and Expressions, B035-1211 for more information about the EXTRACT function. Note that 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.