sql code 1403 and records getting rejected..
Posted: Wed Nov 10, 2010 4:12 pm
Hi All,
My source is having varchar of "2010/11/31" format and my target is column having timestamp ...database on target is oracle...
Iam using stringtodate(col,'%yyyy/%mm/%dd') and all records are geting rejected giving 1403 as sql code..
As target is timestamp i used
if IsNotNull(col) or Trim(col)<>'' then Stringtotimestamp((col:" 00:00:00"),"%yyyy/%mm/%dd %hh:mm:ss") else SetNull()
Another method used for left input as string with col:" 00:00:00" and in insert query i used
to_date(orchestrate.col,'YYYY/MM/DD HH:MI:SS')
its giving error as invalid month...
I was getting error as invalid time...
Any suggestions how to make it work....
Thank you..
My source is having varchar of "2010/11/31" format and my target is column having timestamp ...database on target is oracle...
Iam using stringtodate(col,'%yyyy/%mm/%dd') and all records are geting rejected giving 1403 as sql code..
As target is timestamp i used
if IsNotNull(col) or Trim(col)<>'' then Stringtotimestamp((col:" 00:00:00"),"%yyyy/%mm/%dd %hh:mm:ss") else SetNull()
Another method used for left input as string with col:" 00:00:00" and in insert query i used
to_date(orchestrate.col,'YYYY/MM/DD HH:MI:SS')
its giving error as invalid month...
I was getting error as invalid time...
Any suggestions how to make it work....
Thank you..