The final word on storage for DATETIME2
Two years ago I wrote a post that got a lot of traction in the comments at the time. Last month there was renewed interest… Read More »The final word on storage for DATETIME2
Home »
datetime
How SQL Server stores data types: dates and times
This post dives into how SQL Server stores date and time data types in memory and on disk. But first, a note about endianness: CPUs… Read More »How SQL Server stores data types: dates and times
Dates and Times in SQL Server: DATEADD()
We are now in the home stretch of the long-running series about dates and times in SQL Server and Azure SQL Database. This week we… Read More »Dates and Times in SQL Server: DATEADD()
Dates and Times in SQL Server: AT TIME ZONE
Continuing the series on dates and times in SQL Server and Azure SQL Database, this week we look at the hint AT TIME ZONE. In… Read More »Dates and Times in SQL Server: AT TIME ZONE
Dates and Times in SQL Server: DATEPART()
In my previous posts in this series we’ve seen reference to Transact-SQL (T-SQL) functions that are used to get the specific part of a date… Read More »Dates and Times in SQL Server: DATEPART()
Dates and Times in SQL Server: the problem with DATETIME
Recently I wrote a post about date and time functions you should never use, which contained an opinion I’ve expressed previously that some people have… Read More »Dates and Times in SQL Server: the problem with DATETIME
Dates and Times in SQL Server: more functions you should never use
Previously we looked at four built-in functions to get the current date and time in SQL Server and Azure SQL Database using Transact-SQL (T-SQL). We… Read More »Dates and Times in SQL Server: more functions you should never use
Dates and Times in SQL Server: T-SQL functions to get the current date and time
We have come on quite a journey so far. SQL Server and Azure SQL Database provide date and time data types to help you design… Read More »Dates and Times in SQL Server: T-SQL functions to get the current date and time
Dates and Times in SQL Server: SMALLDATETIME
Last week I spoke about a world wary data type for storing dates and times in a single column, with a granularity of three milliseconds,… Read More »Dates and Times in SQL Server: SMALLDATETIME
Dates and Times in SQL Server: DATETIME
Last year I ran a series of posts about Database Fundamentals. Over the next few weeks, I will cover the basics of various date and… Read More »Dates and Times in SQL Server: DATETIME
Be Wary of Date Formatting in T-SQL
Today’s public service announcement is a reminder to be wary of date formatting in SQL Server. On a recent mailing list discussion, one person demonstrated… Read More »Be Wary of Date Formatting in T-SQL
Data Efficiency in SQL Server: DATETIME
This is the first in a short series of posts about how I assign efficient data types when designing a new table or database. Use… Read More »Data Efficiency in SQL Server: DATETIME