Assume that column tsz has a TIMESTAMP(0) WITH TIME ZONE data type and the current session time zone is INTERVAL -'03:00' HOUR TO MINUTE when the join index that contains tsz is created with the following PARTITION BY clause. The data type of the partitioning expression is INTEGER.
PARTITION BY RANGE_N(CAST(tsz AS DATE AT LOCAL) BETWEEN DATE '2003-01-01' AND DATE '2009-12-31' EACH INTERVAL '1' MONTH)
Vantage implicitly rewrites this partitioning expression, replacing LOCAL with a specific time zone as follows.
PARTITION BY RANGE_N(CAST(tsz AS DATE AT '-03:00') BETWEEN DATE '2003-01-01' AND DATE '2009-12-31' EACH INTERVAL '1' MONTH)