Conversion error
Posted: Thu Mar 23, 2006 9:28 pm
Hi,
In my Job, while I am converting from string (of length 10) to date and string (of length 10) to timestamp.
I gave the condition as -- If it is not a valid date then '0001-01-01' for date and '0001-01-01 00:00:00.000000' for timestamp. But eventhough the input record has a valid date it is giving the default values only in the output.
and the warning i got in the director is as follows
Trns_Validate,0: Conversion error calling conversion routine date_from_string data may have been lost
Plz help me out in this issue.
In my Job, while I am converting from string (of length 10) to date and string (of length 10) to timestamp.
I gave the condition as -- If it is not a valid date then '0001-01-01' for date and '0001-01-01 00:00:00.000000' for timestamp. But eventhough the input record has a valid date it is giving the default values only in the output.
and the warning i got in the director is as follows
Trns_Validate,0: Conversion error calling conversion routine date_from_string data may have been lost
Plz help me out in this issue.