Home Forums SQL Server 7,2000 T-SQL Error with Oracle linked server & Date RE: Error with Oracle linked server & Date

  •  

    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.