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

25,097 reads

Blogs

ConFoo–The Future of Database Development in Containers

By

I delivered a talk at the ConFoo conference. I’ve never been to this live,...

Daily Coping 25 Feb 2021

By

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

2020 Advent of Code–Day 3

By

This series looks at the Advent of Code challenges. As one of my goals,...

Read the latest Blogs

Forums

Shortcutting Git Commands

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Shortcutting Git Commands

What's a Lot of Money?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item What's a Lot of Money?

Newb - SQL Server IIF() Function

By FGJ

I am using the following function: IIf([var1Title] != '', [var1Title] + ' - '...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers