Working with date/time datatypes in T-SQL can be quite frustrating if you don’t have the tools and know-how. Let me arm you with all the knowledge you need to correctly model, convert, index and query your date/time data in a logical and easy-to-understand manner.

We’ll cover the wide range of datatypes available in SQL Server/Azure SQL, and help you understand which ones are right for your goals. We’ll dig in to explicit and implicit conversions, optimal indexing strategies, and some hidden gotchas when working with date/time data.

For the icing on the cake, we’ll also look at some horrible real-world anti-patterns from the trenches, and how to address them like a pro.