1 Reply Latest reply on May 23, 2014 11:27 PM by BKBK

    Get all records updated in last 15 minutes

    weezerboy Level 1

      I need to query and get all records that have been updated in the past 15 minutes.

       

      Ive tried in CF and MS SQL

       

      Here is what I have that doesn't work

       

      SELECT *    FROM  job_clock WHERE  Job_Time_Out >  dateadd(minute,-15,CURRENT_TIMESTAMP)