Click here to Skip to main content
13,344,273 members (77,253 online)
Click here to Skip to main content

Accurate DATETIME Range Searching in SQL Server

, 16 Feb 2016
You can also get the correct result by passing time along with the date.ExampleIf you have to search records between 1st Apr 2010 and 5th Apr 2010, then:Select * from TableNameWhere DateField Between '04/01/2010 00:00:00' And '04/01/2010 23:59:59'
This article is not currently available for viewing.

Please go to the Programming Tips Table of Contents to view the list of available articles in this section.
Closed because this item's quality is too poor to be published. Reported by Sascha Lefèvre, Richard Deeming, Kornfeld Eliyahu Peter, OriginalGriff, Wendelius on Tuesday, February 16, 2016 6:53am

You may also be interested in...

Pro
Permalink | Advertise | Privacy | Terms of Use | Mobile
Web03 | 2.8.180111.1 | Last Updated 16 Feb 2016
Article Copyright 2010 by Chetan Patel
Everything else Copyright © CodeProject, 1999-2018
Layout: fixed | fluid