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



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net