Home Forums SQL Server 7,2000 T-SQL Error with Oracle linked server & Date RE: Error with Oracle linked server & Date
jaredsimi
SSCrazy
Points: 2420
More actions
February 27, 2004 at 6:44 am
#496169
Oracle can use casts to convert dates as well.
oracle doesn't have a datatype called datetime. OpenQuery is executed as a passthru query on the remote server. Thats why you are receiving a ora- error. Try removing the cast specification.