在SQL Server中，如何通过链接服务器连接查询Oracle Timestamp列? [英] In SQL server, how can I query an Oracle Timestamp column over a Linked server connection?

问题描述

我在oracle中进行的查询不适用于sql server 2008的链接服务器.

The query I have made in oracle does not work with linked server with sql server 2008.

为链接服务器"ORACLE"提供了OLE DB提供程序"MSDAORA" 列"DATETIME_INS"的元数据无效.数据类型不是 支持.

The OLE DB provider "MSDAORA" for linked server "ORACLE" supplied invalid metadata for column "DATETIME_INS". The data type is not supported.

查询:

select * from ORACLE..U_GERAN.CELLSTATS4

执行查询必须进行哪些修改.

What are the modification that must be done to execute the query.

推荐答案

尝试，

SELECT * 
FROM OPENQUERY(ORACLE, 'select cast(DATETIME_INS as DATE) from U_GERAN.CELLSTATS4')

该列起作用后，您可以将其他列添加到查询中.

You can add the other columns to the query once that column works.

这篇关于在SQL Server中，如何通过链接服务器连接查询Oracle Timestamp列?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！