How to Search for Date and Time Values Using SQL Server 2000

(Page 1 of 8 )

Before you can effectively query date/time (or temporal) data, you have to know something about how date/time values are stored.  In this article, Bryan demonstrates the various ways in which to query an SQL Server to successfully retrieve the records you may be seeking.

Suppose you’re writing a query to find all the invoices that were written on January 6, 2003. You know from the control totals that 122 invoices were written that day. But when you run this query:

SELECT * FROM Invoices
WHERE InvoiceDate = '2003-01-06'

The result set is empty. What’s going on?

Next: How Dates and Times are Stored in SQL Server >>
 

More SQL Server Articles
More By Bryan Syverson

Comments On: How to Search for Date and Time Values Using SQL Server 2000

>>> Be the FIRST to comment on this article!