Posted by Plamen Ratchev on 02/08/07 18:41

You can return all records with today's date using a WHERE condition like
this:

WHERE mydate >= DATEDIFF(day, 0, getdate())
AND mydate < DATEDIFF(day, 0, getdate() + 1)

HTH,

Plamen Ratchev
http://www.SQLStudio.com

• Next in forum: Re: Need advice on system performance
• Prev in forum: Re: Who Turned off the SQL Server AGENT???!!!!
• Thread view: Re: Need help running query on data/time field

[Reply to this message]