Itzik Ben-Gan outlined three methods in the Feb. 2007 issue of SQL Server magazine. His preferred method is this:

SELECT DATEADD(day,DATEDIFF(day,'19000101',GetDate()),'19000101')

While it was not quite the fastest it was up there with another solution that is not in this thread. This solution he said was twice as fast as the others on 1,000,000 iterations.



>Consider the following select statement:
>

>SELECT	[Id]
>FROM	[MyTable]
>WHERE	YEAR(DateField) = YEAR(@DateField) AND
>	MONTH(DateField) = MONTH(@DateField) AND
>	DAY(DateField) = DAY(@DateField)
>

>
>I want to select the records that have the same date as the parameter, but I do not care about the time part of the field or parameter.
>Is there another (better) way of doing this?
>
>Thanks,
>Einar