Timestamps Oracle OCI to OLE/DB??
Posted: Mon May 15, 2006 7:18 pm
Hi all. I'm finding some interesting behavior around timestamps. I've defined columns on both the Oracle and SQLServer side as 'Timestamp'.
My job is as follows:
What I'm seeing is as follows:
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.
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...