Posted by Jens on 10/01/74 11:45

Use the dateadd (Or Datediff) for that:

hit_date >= DATEADD(d,-2,GETDATE()), keep in mind that this will
substract the days including the current time, so a 04/19/2006 1:09
will result in 04/17/2006 1:09.

HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---

• Next in forum: Re: Timeout errors
• Prev in forum: Re: Get all records from Last Two Days?
• Thread view: Re: Get all records from Last Two Days?

[Reply to this message]