Reply to Re: Need help running query on data/time field
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