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,914 reads

Blogs

Secure Azure SQL Server Backups Using Managed Identities

By

I do believe most people know about the ability to backup your SQL server...

Using a Local Large Language Model (LLM): Interacting with Local LLMs Using PowerShell

By

As AI continues to evolve, many of us are looking for ways to leverage...

Monday Monitor Tips: Finding the Hostname for Queries

By

I was chatting with a customer recently and they wanted to know which host...

Read the latest Blogs

Forums

Internationalisation

By julian.fletcher

Quick one I hope in case I'm heading off in entirely the wrong direction!...

Size of DB on physical disk doesn't match Disk Usage by Table report

By water490

Hi everyone I am looking at the size of my db on disk (ie...

Getting the TEXTSIZE

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Getting the TEXTSIZE

Visit the forum

Question of the Day

Getting the TEXTSIZE

How can I check what value I used for TEXTSIZE? I ran this code:

SET TEXTSIZE 8096
But then deleted the code and couldn't remember. Is there a way to check this?

See possible answers