DSXchange

Hi

while i am converting a null value to Time-stamp,the job is getting aborted with the error

APT_CombinedOperatorController,0: Conversion error calling conversion routine timestamp_from_string data may have been lost

and i had written the logic as

i want the output as 1858-11-17 00:00:00 for all null values,
can any one post the code to me.


Thanks
Praveen

Try StringToTimestamp("1858-11-17 00:00:00")

You need to supply a matching format mask so it knows how to parse the incoming string.