All Forums Database
wgfagundes 3 posts Joined 08/16
24 Aug 2016
ODBC TimeStamp

Hi Guys,
It's my first topic here, I'm new on Teradata and we are facing a problem with ODBC with Timestamp. Let me explain the situation:
We have a Oracle GoldenGate running on IBM AIX replicating transactions to our Teradata 15.00. In our Teradata we have a Table that has a column with TIMESTAMP(6) WITH TIME ZONE NOT NULL.
When we receive the records from the GoldenGate, the output for this column in this way:

28 I 2016-02-20 23:00:20.065771-00:00

27 I 2016-02-20 23:59:58.065771-00:00

29 I 2016-02-21 01:21:52.065024-00:00

30 I 2016-02-21 01:21:52.065024-00:00


But, the output should be this way:


28 I 2016-02-20 23:00:20.065771-02:00

27 I 2016-02-20 23:59:58.065771-02:00

29 I 2016-02-21 01:21:52.065024-03:00

30 I 2016-02-21 01:21:52.065024-03:00


I've found that ODBC has some limitations with Timezone, do you guys have sometips with this issue?


Thank you so much,

You must sign in to leave a comment.