stringtoTimestamp

bakshdwh · Post by **bakshdwh** » Sat Jun 23, 2012 3:49 am

Hi
Im trying to convert string to timestamp and I get the following error

APT_CombinedOperatorController(2),2: Conversion error calling conversion routine timestamp_from_string data may have been lost

the input column value from the sequential file is for example

CRT_DATE 2006-03-15 19:39:12

I need to insert this into a timestamp column in oracle

I've also noticed in the peek stage that some values are :
Peek_63,2: CRT_DATE:*******************

Help on this is much appreciated.

Thanks

chulett · Post by **chulett** » Sat Jun 23, 2012 7:30 am

Show us your syntax.

bakshdwh · Post by **bakshdwh** » Sun Jun 24, 2012 2:15 am

Hi
Thanks
It was not reading the null values, specified the null value, and the job is working fine now.

Thanks