My job is as follows:
Code: Select all
OCI-->Trans-->OLE/DB
1. null dates in Oracle are trying to be written as '0000/00/00 00:00:00' in SQLServer
2. inconsistency in passing the actual date value; oracle values of '2006-05-12 00:00' are mysteriously translated to '05/11/2006 00:00:00'
Can anyone out there recommend any techniques to use regarding this? I've tried converting to the internal Date format, but that didn't seem to help.
Thanks in advance.
Loving the Micro$oft HRESULT errors.. makes everything so obvious...