Bryan Syverson


SQLServerCentral Article

How to Search for Date and Time Values

Because of the way date and time values are stored in SQL Server, searching for a particular date or time is not 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.

5 (1)

You rated this post out of 5. Change rating

2003-01-21

35,470 reads

Blogs

SQL Saturday Boston 2024 Slides

By

Thanks to everyone that came to my talks. Slides are below. Best Practices for...

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Read the latest Blogs

Forums

Impact of adding the opening of the Master Key in a SQL job for SSIS packages

By abdalah.mehdoini

Bonjour à tous, J'ai un problème d'exécution de mes packages SSIS. A chaque opération...

Being an extroverted introvert at a conference

By Louis Davidson (@drsql)

Comments posted to this topic are about the item Being an extroverted introvert at...

Need to group the same valued ID fields to run an aggregate average over them

By Zososql

I have data that contains poll results, with the poll_id consistuting a single row...

Visit the forum

Question of the Day

How are statistics stored?

How are the statistics for query optimization stored in SQL Server?

See possible answers