How to convert currenttimestamp() to load into timestamp(0)

MohanShanmugam · Post by **MohanShanmugam** » Tue Dec 28, 2010 9:14 am

Hi ALL,

This is my first post in this forum.

I am having issue in loading currenttimestamp() which is used in transformer stage to load it into column having datatype timestamp(0) in teradata.

It is loading well if i change the datatype as timestamp(6) in teradata. But, the requirement is to have timestamp(0) in DB level.

It would a great pleasure to me if I get inputs and help to solve it.

Thanks,
Mohan Shanmugam.

MohanShanmugam · Post by **MohanShanmugam** » Tue Dec 28, 2010 9:19 am

Forgot to mention the utility used. We are using TPump utlity to load data into Teradata table.