Timestamp with timezone

Teradata Applications
Enthusiast

Timestamp with timezone

Hi,

 

The data that i get is below and i need to insert this into TD with the timezone. Can you tell me what the data type in the table should be so that i can insert this using a tpt script?

2016-10-16 17:45:41.775+11

 

P.S: I have tried creating the coulmn as timestamp(6) with time zone and it dint work. it would just end up in the error table...

 


Accepted Solutions
Senior Apprentice

Re: Timestamp with timezone

Teradata expects the time zone in an HH:MM format, so simply concat zero minutes to the existing data ( ts_string||':00') and define the target column as TIMESTAMP(3) WITH TIME ZONE

1 ACCEPTED SOLUTION
2 REPLIES
Senior Apprentice

Re: Timestamp with timezone

Teradata expects the time zone in an HH:MM format, so simply concat zero minutes to the existing data ( ts_string||':00') and define the target column as TIMESTAMP(3) WITH TIME ZONE

Enthusiast

Re: Timestamp with timezone

Thanks so much....that worked like a charm! :-)