convert varchar to timestamp

[times29]

Hi,
I have column year datatype varchar which goes in to column date datatype timestamp and i am getting errors how can i convert varchar to timestamp keeping the same format

so

Code: Select all

Source (Varchar)                   Target(timestamp)
2004                               2004
2005                               2005

I am using transformer for conversation

[ray.wurlod]

You don't have a timestamp in your data. You have merely a year.

[chandra.shekhar@tcs.com]

@times29
Just a bit of thinking will show you that just a year part cannot be stored in to a timestamp. You have to have a month, date and time along with the year. So either you have to hardcode a value into those places(month, date and time) or dynamically generate it, may be for example use a CurrentTimestamp() function.