SQLServerCentral / SQL Server 7,2000 / Working with Oracle / Openquery with ALTER SESSION SET NLS_DATE_FORMAT = "DD/MM/YYYY HH24:MI:SS / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 18:57:49 GMT20RE: Openquery with ALTER SESSION SET NLS_DATE_FORMAT = "DD/MM/YYYY HH24:MI:SShttp://www.sqlservercentral.com/Forums/Topic602047-1043-1.aspxHow?Mon, 01 Jun 2009 10:25:02 GMTfranzambestenRE: Openquery with ALTER SESSION SET NLS_DATE_FORMAT = "DD/MM/YYYY HH24:MI:SShttp://www.sqlservercentral.com/Forums/Topic602047-1043-1.aspxuse Execute immediate statementMon, 01 Jun 2009 09:26:36 GMTaj-753163Openquery with ALTER SESSION SET NLS_DATE_FORMAT = "DD/MM/YYYY HH24:MI:SShttp://www.sqlservercentral.com/Forums/Topic602047-1043-1.aspxHiI need to know if it is possible to use openquery within a statement to execute the alter session sentence for oracle db.Sorry for my englishIf this is not the rigth place for the question, would you please direct me ?thanks in advance for any help !Thu, 13 Nov 2008 06:43:28 GMTfranzambesten