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 www.sqlmag.com
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