InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 08:20:10 GMT20http://www.sqlservercentral.com/Forums/Topic1347176-1042-1.aspxCross post, please answer here: [url]http://www.sqlservercentral.com/Forums/Topic1347483-1044-1.aspx[/url]Mon, 20 Aug 2012 15:50:06 GMTPaulB-TheOneAndOnlyhttp://www.sqlservercentral.com/Forums/Topic1347176-1042-1.aspxHello Oracle Forum:I've got my first linked server established from SQL Server 2008 SSMS to Oracle.What is the proper syntax for this simple query with a date expression in the where clause?What is the proper date delimiter?Is there a conversion necessary?SELECT TOP (5) SURGERY_DATEFROM OPENQUERY(CLARITY, 'SELECT * FROM OR_LOG WHERE SURGERY_DATE = ('8/1/2012')' AS aMany thanks ahead of time.PhunhogMon, 20 Aug 2012 07:46:17 GMTPhunhog