Home Forums SQL Server 2008 Working with Oracle Function to Convert Current Date to SQL Sever Date format. RE: Function to Convert Current Date to SQL Sever Date format.

  • September 2, 2014 at 8:04 am

    #1742453

    I do not oracle but after a quick google search, try this

    SELECT *

    FROM OPENQUERY (LS_RDB_DWH, 'SELECT * FROM RDB_DWH.ENTITY_DIMENSION WHERE PD_RDB_ENTRY_DATE >= TRUNC(SYSDATE)')

    Far away is close at hand in the images of elsewhere.
    Anon.