Database Discussion - Records in last 10 min

Print Page | Close Window

Records in last 10 min

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=21858
Printed Date: 28 March 2026 at 7:54am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Records in last 10 min

Posted By: zMaestro
Subject: Records in last 10 min
Date Posted: 07 November 2006 at 9:52am

Hi,

How can i display all the records added to the database in the past 10 minitues. The database is sql.

Thank you.

Replies:

Posted By: michael
Date Posted: 07 November 2006 at 2:13pm

should work:

select * from table where datediff("n",change_dt,getdate()) <=10

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker