Conversion to Timestamp

abhilashnair · Post by **abhilashnair** » Mon Dec 22, 2014 4:21 am

My input is string and data will be like dd-Mon-yyyy
eg: 10-Dec-2010

I need to load the above as timestamp into target Teradata table

Please suggest

sarathchandrakt · Post by **sarathchandrakt** » Mon Dec 22, 2014 5:50 am

You can just append 00:00:00 to the existing string

input.Column_Name:' 00:00:00'

Then use StingToTimestamp() function to convert it to timestamp

StringToTimestamp(input.column_name:' 00:00:00', "%dd-%mmm-%yyyy %hh:%nn:%ss")

ray.wurlod · Post by **ray.wurlod** » Mon Dec 22, 2014 7:58 am

What format of timestamp is your Teradata instance expecting?

abhilashnair · Post by **abhilashnair** » Mon Dec 22, 2014 9:40 pm

The target Teradata table is expecting Timestamp without microseconds

chulett · Post by **chulett** » Mon Dec 22, 2014 9:45 pm

Sorry but that doesn't answer the question. What format is it expecting? Spell it out for us like YYYY-MM-DD HH... etc etc.

abhilashnair · Post by **abhilashnair** » Mon Dec 22, 2014 9:53 pm

It is expecting yyyy-mm-dd hh:nn:ss

abhilashnair · Post by **abhilashnair** » Mon Dec 22, 2014 11:42 pm

StringToTimestamp(input.column_name:' 00:00:00', "%dd-%mmm-%yyyy %hh:%nn:%ss")

The above worked for me