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

16,956 reads

Blogs

SSAS Tabular – Process Add memory consumption

By

For me it’s a bit surprising how little information can be found regarding the...

Our SQL Server 2019 Administration Inside Out Fun Author Survey

By

SQL Server 2019 Administration Inside Out Honored again to be leading the talented SQL Server...

What's New in SQL 2019? at the Data Architecture Virtual User Group and Q&A followup

By

Thanks to all 180+ of you who joined the Data Architecture Virtual User Group...

Read the latest Blogs

Forums

How to populate Temp table from Stored Procedure

By rkordonsky 63916

I am trying to put the result of Stored Procedure execution into Temp Table:...

Web page listing SQL code

By EamonSQL

Hi, I'm building a web page for my users that will list example SQL...

Going from Failover Cluster Instance to Availability Group with Azure Replica

By jcourtjrSQL

So if we have a FCI on premises, and want to add Availability Group...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers