Using CASE_N with CURRENT_DATE or CURRENT_TIMESTAMP in a PPI - Teradata Vantage

You can define a partitioning expression that uses CASE_N with the built-in functions CURRENT_DATE or CURRENT_TIMESTAMP. Subsequently, you can use the ALTER TABLE TO CURRENT statement to re-partition the table data using a newly resolved current date or timestamp.