Sometimes when doing a search for between ranges, some of the data is omitted because the search doesn’t the whole last day’s . Here is a small trick to always get all the data between a specified .

Declare @fromDate DATE
Declare @ToDate DATE
SELECT Date From Table
   WHERE.Date BETWEEN CAST(@fromDate AS DATE) and DATEADD(s,-1,DATEADD(d,1,@ToDate)) --To Date Minus 1 second to include the whole last day's values



Source link
thanks you RSS link
( http://www.devx.com//database-development/sql/include-all-values-in-a-date-range-by-using-minus-1-second-trick-180221106.html)

LEAVE A REPLY

Please enter your comment!
Please enter your name here