How to search for date and time values using Microsoft SQL Server 2000
Because of the way date and time values are stored in SQL Server 2000, searching for a particular date or time isn’t as straightforward as you might think it would be. This article describes how date/time values are stored, how the database design can simplify (or complicate) data retrieval, and how to query date/time data to get the right results every time.
Views: 1346 | | by Slicer
View this tutorial