Hi folks,
I am trying to have some data from an oracle database available in remedy,
which is using SQL server.
I have setup a linked server to the oracle DB and using openquery everything
works well if I cast the DATE field in oracle to CHAR. The problem is the date
field in remedy translates to a character field, which you would expect. IS
there a way for me to CAST the date field in oracle to a DATETIME field in SQL
which Remedy would recognize as a date field when creating the view? I am not
using the MSDAORA provider.
Thanks
Steve
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"