Posted by Mark D Powell on 05/31/06 15:30

MartyP wrote:
> 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

I have never seen this problem, but could you verify that the Oracle
mydate column datatype is a defined as DATE or as a TIMESTAMP? If it
is a timestamp is it a timestamp with timezone by any chance?

HTH -- Mark D Powell --

• Next in forum: Re: Question on Transaction Log Backups
• Prev in forum: Re: Very chalanging question - Explanation
• Thread view: Re: Linked Server Time Difference

[Reply to this message]