Get all records updated in last 15 minutes

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)

This topic has been closed for replies.

Community Expert

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

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

Sign up