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?
Defalt date is inserting into Date field in Oracle database
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 10
- Joined: Thu Sep 27, 2007 5:15 am
- Location: hyd
i thing u just insert date as a default in job property
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
or
if u using transformer stage there u must choose datatype date
------------
rajeshds