How to convert currenttimestamp() to load into timestamp(0)
Posted: 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.
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.