Get all records updated in last 15 minutes

[weezerboy]

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)

[BKBK]

Are you sure Job_Time_Out is a date? Try the alternative,

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