Help for the DATETIME data type and DST on SQL Server

Help for the DATETIME data type and DST on SQL Server

We've noticed a surge in the number of searches for articles on the DATETIME data type on the site lately.  So, we thought a consolidated list of DATETIME articles 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

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

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



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.