Help for DST and DATETIME on SQL Server

More resources for DST conversions and DATETIME on SQL Server

Did you survive the move to Daylight Savings Time (DST)? We know this has been a very hot topic for you in the last few months based upon the number of searches for DST article on our website. The other thing we're noticing is a huge surge in the number of searches for articles on the DATETIME data type on our SQL Server site at
We thought it would be useful to give you a consolidated list of DATETIME articles that might come in handy if you are still dealing with the fallout from DST from the SQL Server perspective.  Just click on the article to link to it. 
Good luck and let us know if we can help you with other resources.

DATETIME Calculations, Part 1 provides you with trimming techniques to return only the date or the time of a given datetime value.

DATETIME Calculations, Part 2 shows you how to calculate start and end values and language-independent weekdays

Correctly Calculating Datetime Differences shows you how to transcend DATEDIFF()'s limitations

Automate Date/Time Conversions is an extensible, flexible, data-driven utility that can handle all your date-formatting needs

Solving the Datetime Mystery explains the nuances of how SQL Server stores and treats the datetime data type

When Datetime Data Types Behave Strangely helps you troubleshoot the strange behavior of datetime values

Manipulate and Calculate shows how to effectively use dates and times to meet your business needs

Datetime for Durable Databases compares two datetime formatting solutions, one clear winner--the scalar UDF

Just in Time talks about the imprecise nature of the DATETIME data type

Simplify, Parameterize, Reuse shows how to encapsulate your complex datetime expressions and reuse the code

The Datetime Dilemma dissects the topic of storing date and time data by reviewing storage basics, data-entry options, and date and time data display formats

Reporting Sales solves a series of problems trying to create reports with different time and date slices from the same sales data

Making History discusses preserving your database's history records without sacrificing performance

T-SQL's Datetime Data Type answers six commonly asked questions about how to use SQL Server's datetime data types

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.