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

Teradata Database SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Release Number
15.10
Published
December 2015
Content Type
Programming Reference
Publication ID
B035-1144-151K
Language
English (United States)
Last Update
2018-06-05

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)

Teradata Database 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)