Defalt date is inserting into Date field in Oracle database

reddy82 · Post by **reddy82** » Fri Sep 28, 2007 3:17 am

Hi

When loading null date into Oracle table using the Load functionality the dates are getting loaded correctly but while using the upsert functionality Update then Insert a strange value like '30-12-1899' gets loaded for null values. Can someone explain this ocurence or a workaround it?

ray.wurlod · Post by **ray.wurlod** » Fri Sep 28, 2007 5:56 am

Welcome aboard.

Does the Oracle table have this as the default value for this date column?

rajeshkadiri · Post by **rajeshkadiri** » Fri Sep 28, 2007 8:39 am

i thing u just insert date as a default in job property
or
if u using transformer stage there u must choose datatype date

------------
rajeshds