Click here to Skip to main content
12,695,739 members (32,147 online)
Click here to Skip to main content

Accurate DATETIME Range Searching in SQL Server

, 16 Feb 2016 CPOL
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, Mika Wendelius on Tuesday, February 16, 2016 6:53am

You may also be interested in...

| Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.170118.1 | Last Updated 16 Feb 2016
Article Copyright 2010 by Chetan Patel
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid