Select Records from the last 10 minutes

[Anon]

I am working on something where I need to select all records that have the date/time within the last 10 minutes.

I can do the last 10 days one using:

(TO_DAYS(NOW()) - TO_DAYS(date) = '10')

...but not the last 10 minutes!

Any help is greatly appreciated.

[rikblank]

(((360060)60)*10) if its timestamp

[rikblank]

That would be (((360060)24)*10) for seconds

[rikblank]

Man I'm a going stupid or what 3600 = 1 hour 24 for one day 10 for your ten days would be ((360024)10)