Search results

  1. I

    Issue with TIMESTAMPDIFF from SQL Server

    I'm trying to run a simple comparison of dates in a DTS script on SQL Server 7 pulling in date from a Progress database. The code I am trying to run is: SELECT * FROM IRECOF WHERE TIMESTAMPDIFF(SQL_TSI_DAY, CURRENT_DATE, IRDTTR) <= 2 (IRDTTR is a transaction date field in the Table IRECOF...
Back
Top