Example: Partitioning Expression that Specifies an AT LOCAL Date - Teradata Database

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)

Theg system 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)