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)

2003-01-21

32,825 reads

Blogs

Join Denny Cherry and Associates at SQL Bits 2023

By

I am very excited and lucky to be speaking once again at SQLBits along...

Daily Coping 27 Jan 2023

By

Today’s coping tip is to try something new to get out of your comfort...

Things to look out for while TDE is encrypting existing data

By

Monitoring for Problems The encryption of your existing data occurs as a background process...

Read the latest Blogs

Forums

Database Migration

By mxy

can you please provide your feedback on following scenario. i am migrating a database...

Sampling : Select the sample records

By komal145

hi, I have a data like below where i need to randomize data by...

ROUND or CONVERT the output of the POWER function

By Chrissy321

Hello smart people, I am trying to use the POWER function to return data...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers