Ken,

You have two options. First you can use the between:

orderdate BETWEEN '19990501' AND '19990501 23:59:59:999'

Your other option is to use the DATEPART() function and apart the date into day-of-year and year:

DATEPART(yy, orderdate) = DATEPART(yy, '19990501) AND
DATEPART(dy, orderdate) = DATEPART(dy, '19990501)

The downside is that SQL Server won't be able to optimize the expression.

-Mike


>Hi all,
>
>How does one get the 'date" from a SQL server "DateTime" expression. If the answer is "you don't", then how does one go about doing date comparisons in searches?
>
>For example ... if I have a field called "OrderDate" that is filled with GetDate(), it is going to have something like "05/01/99 10:24:36:345 AM" stored in it. Now, how can I construct my where clause to find all records with an order date of "05/01/99" ? Obviously a search for "OrderDate = "05/01/99" wouldn't work because of the time portion of the value.
>
>Thanks!
>Ken