confused with dates [message #373183] |
Mon, 02 April 2001 18:19 |
JOHN
Messages: 182 Registered: April 1998
|
Senior Member |
|
|
I have written a vb app that selects data in an Oracle table and writes it to a table in SQL Server. Why? Well, cause someone said it has to be done! Anyways, the Oracle table has a field TRANSDATE type Numeric. It has values in it like 96754.00192837 The SQL Server has a field TDATEHIST type Date/Time.
When I look at the TDATEHIST field in SQL Server the date is 2 days greater than the value in Oracle.
Using a 3rd party proprietary app I can see the transactions and they have a date of 3/26/01. After my SQL Server insert, the date is 3/28/01.
I know I could subtract 2 but don't know if this is true for all dates.. has anyone came across this?
Changing the field type in Oracle is not an option.
Thanks
|
|
|