My specific use of the datetime field is to see if it occurs

within a user specified date range.

The examples I received with the stored procedures (from software application vendor)

had the user enter full date and time (2014-01-14 23:59.59)when I am not interested in the time aspect.

I changed to have the user just enter the date ('2014-01-14') which defaults to zero time.

If inclusive start date and end date are entered, with the default zero time, I would miss

the last date, so I compare

between @startdate and @enddate + 1

which does include the entire enddate.