Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
 

Tip: How to Include All Values in a Date Range

See how to include all values in a date range by using the minus 1 second trick.


advertisement

WEBINAR:

On-Demand

Application Security Testing: An Integral Part of DevOps


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

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

 

Visit the DevX Tip Bank

 





   
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date