Time In SQL

[Silvinho]

using the query

SELECT *
FROM Chat
WHERE Date_Entered Between Now() And Now()-5
ORDER BY Date_Entered ASC

gives me the all the records over the last 5 days

How do you change the SQL so that instead of selecting days, you can select time, giving me all the records from say the last 5 minutes?

 

[aalmeida]

Try use the DATEDIFF() function check it out at:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlce/sqlceref_5vxi.asp

Let me know AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"