query recs created in the last 10 minutes...

bryonb · #1 (**permalink**) 10-08-03, 22:54

How do I write a select statement that will return only the records created in the last 10 minutes. I have a field called dt_created that is a datetime type.

neelamchalam · #2 (**permalink**) 10-09-03, 00:19

HI,

try with this query

select * from timedif where MINUTE( ts ) >= ( MINUTE (current timestamp) -10);

Regards,
Chalam N

Quote:

Originally posted by bryonb
How do I write a select statement that will return only the records created in the last 10 minutes. I have a field called dt_created that is a datetime type.

Internet Services

Web Development

Digital Marketing

Consumer Tech