Ever needed to-do this in SQL?

select * from ATABLE

where [SomeDate]=@A_DATE_YOU_WANT_TO_LOOKFO

Now suppose that you want to ignore times as SQL Server's DateTime object stores the time along with the date.

You can modify the query to-do just this.

select * from ATABLE

CAST(FLOOR(CAST( [SomeDate] AS float)) AS datetime) = @A_DATE_YOU_WANT_TO_LOOKFO

Obviously the variable @A_DATE_YOU_WANT_TO_LOOKFO should  have its time set to midnight,  but this works great.