Oracle Date field to Timestamp
Posted: Thu Mar 16, 2006 5:38 pm
Hi Gurus,
I have both source and target tables as Oracle database.I am using custom sql in the source table to load into target.
I have a situation like this:
for postdate field source datatype is numeric but target datatype is timestamp
so in userdefined SQL i used
to_date(J1.JC_COST_DATE,'YYYYMMDD')
for currentfield is date datatype in source table but timestamp in target table
while running the datastage job i am getting following error:
Attempt to convert String value "15-MAR-06" to Timestamp type unsuccessful
Can you please light on me.
Thanks in advance.
Reddy
I have both source and target tables as Oracle database.I am using custom sql in the source table to load into target.
I have a situation like this:
for postdate field source datatype is numeric but target datatype is timestamp
so in userdefined SQL i used
to_date(J1.JC_COST_DATE,'YYYYMMDD')
for currentfield is date datatype in source table but timestamp in target table
while running the datastage job i am getting following error:
Attempt to convert String value "15-MAR-06" to Timestamp type unsuccessful
Can you please light on me.
Thanks in advance.
Reddy