Posted by MartyP on 05/31/06 12:45

I am using SQL 2000 and/or SQL 2005 to link to an Oracle Db using
OPENQUERY.
The SQL 2000 box is SP4 on Win2000.

I can run a query thru Q.A. for SQL 2000 or I can run an Oracle query
thru SQL-Plus to see the data. But, if I run a date-query using the
linked server then SQL Server returns a TIME that is off by 4 hours.

SQL Query:
SELECT * FROM OPENQUERY( ORASERVER, 'SELECT MYDATE FROM MYTABLE')

Oracle Query:
'SELECT MYDATE FROM MYTABLE'

Oracle results:
04/16/2006 01:07:00

SQL 2000 result:
04/16/2006 05:07:00

Has anyone seen this before? Is there a fix?
I have searched the newsgroups and MS Kb but can not find an answer.

Thanks,
Marty

• Next in forum: Re: Very chalanging question - Explanation
• Prev in forum: Re: VERY chalanging question - Explanation
• Thread view: Linked Server Time Difference

[Reply to this message]