How To Get Proper Range Of Dates And Compare of Two Dates In Sqlserver 2005


declare @startDate varchar(20) declare @endDate varchar(20) set @startDate = ’01/01/2008′ set @endDate = ’04/01/2008′

SELECT min(date),max(date) FROM view_Inspections WHERE CAST(FLOOR(CAST(date AS FLOAT)) AS DATETIME) BETWEEN CAST(@startDate AS DATETIME) And CAST(@startDate AS DATETIME))

Advertisements