DSXchange

Hi all,

Could you please let me know how can I do a Date to Timestamp conversion. I have a job where I have a date format and need to convert to Time stamp format which is output format. I know we can do timestamp to date using TimestampToDate function. But iam not sure how we can do this. i would like to put zero's in time portion. Please help me out.

Regards
Naresh

TimestampToDate() won't help - it goes the wrong way. Do you really need a Timestamp data type, or do you need a string formatted like a timestamp?

Hi,

if you need default time to be added to the date part then you can go for following conversion.

StringToTimestamp(DateToString(DSLink2.da,"%yyyy-%mm-%dd") : ' 00:00:00',"%yyyy-%mm-%dd %hh:%nn:%ss")

thanks.

Use Timestamp data type and use function in transformer stage DatetoTimestamp(ColumnName)