Between in SQL Server Stored Procedure Problem
Posted on 2003-12-09
Here is my stored procedure:
CREATE PROCEDURE summary
select * from SanderGroup
where Entrydate between CONVERT(varchar, CONVERT(smalldatetime, @startdate)) and CONVERT(varchar, CONVERT(smalldatetime, @enddate))
I was under the understanding that between is inclusive, so if I used 11/03/03 as my startdate and 11/05/03 as my end date I should get records with 11/03/03, 11/04/03, AND 11/05/03
But I don't I only get 3, and 4. Am I missing something?