Date Comparison

[ghobbes98]

I have a store procedure at the moment where I pass in a date and if the value in field is equal to this date I want to pass it back to the user. However I only pass in the date as "24/6/2002" but the date in the record might be
"24/6/2002 10.37.30" so it never returns back this value. So I was wondering is it possible to make a comparisson solely on the date part and not on the time as well
Thanks for any suggestions
G

 

[tlbroadbent]

Assume @datein is the input date.

Select *
From table_name
Where date_column >= @datein
And date_column < dateadd(d,1,@datein)

Alternate:

Select *
From table_name
Where convert(char(10), date_column, 103) = @datein Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains &quot;Suggestions for Getting Quick and Appropriate Answers&quot; to your questions.