Posted by Techhead on 02/08/07 18:57

On Feb 8, 12:41 pm, "Plamen Ratchev" <Pla...@SQLStudio.com> wrote:
> 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 Ratchevhttp://www.SQLStudio.com

Awesome! Worked perfect!

• Next in forum: Effective permission for a group
• Prev in forum: Re: Need advice on system performance
• Thread view: Re: Need help running query on data/time field

[Reply to this message]