What is the meaning of this partion

Database
Teradata Employee

What is the meaning of this partion

Hi All,

Please help me to clear the defination of below partition syntex.

PARTITION BY CASE_N(

EDW_END_TS = TIMESTAMP '9999-12-31 23:59:59.999999+10:00',

NO CASE OR UNKNOWN);

when i check dbc,indexconstrain table constarin column is as below

CHECK ((CASE_N(EDW_END_TS = TIMESTAMP '9999-12-31 23:59:59.999999+10:00', NO CASE OR UNKNOWN)) BETWEEN 1 AND 00002)

are we creating single partition ??  what is mean by +10 and between 1 and 00002.

please help.

1 REPLY
Enthusiast

Re: What is the meaning of this partion

Hi Sandeep,

The +10 is the Time Zone

You are defining two partitions, the equal to literal timestamp and all others distinct to the literal.

Regards.