>>>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
>>
>>

>>DECLARE @myDate datetime
>>set @myDate = convert(varchar(8),@DateField,112)
>>
>>select [id] from [myTable] WHERE DateField between @myDate AND @myDate + 1
>>

Cetin
>
>Cetin,
>
>this solution has a tiny bug : the next day midnight precise is selected also, and Murphy is never far away ...
>
>As a solution use Dateadd(second,86399, @myDate) as enddate. 86399 = 86400 seconds in a day minus 1. But even here, the last millisecond of the day isn't selected :-(

Pascal,
I have already noticed and updated:) Check first reply.

PS: Dateadd() solutions are somewhat ugly because SQL server cannot resolve less than 3 milliseconds. ie: To SQL server 2000,1,1 23:59:59.999 is 2000,1,2 0:0:0
Cetin