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

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

Assume that column ts has a TIMESTAMP(0) without time zone data type and the current session time zone is INTERVAL '04:00' HOUR TO MINUTE when the table that contains column ts is created with the following PARTITION BY clause. The RANGE_N function has an INTEGER data type.

     PARTITION BY RANGE_N(CAST(ts 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(ts AS DATE AT '04:00') 
                          BETWEEN DATE '2003-01-01' 
                          AND DATE '2009-12-31'
                          EACH INTERVAL '1' MONTH)