Bryan Syverson


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

28,425 reads

Blogs

SQLSaturday Orlando 2021 – September Update

By

Just over 30 days until SQLSaturday Orlando and I’m using some vacation time today...

Audit Columns

By

One of the easiest ways to collect information about table activity is to add...

Daily Coping 28 Sep 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Issue with the change of the column precision to be 2 decimal places

By JeremyU

Hello, I need to  change the % sales vs forecast column precision to be...

Social Media Link Aggrigator

By suvina

Need a way to put all of your social media links and profiles into...

Implicit conversion from datetime to datetime2

By Alessandro Mortola

Comments posted to this topic are about the item Implicit conversion from datetime to...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers