How to Master DATETIME Functions Like a Boss in 59.5 Minutes or Less

Peter Doyle

Can you answer these three questions?

1. Which date and time data types have a precision of 3 1/3 milliseconds and 100 nanoseconds, and why could that matter on December 31, 2043?

2. Can you write a query to list the dates of the first Monday, second Tuesday, third Wednesday, and fourth Thursday of any month between week 22 and week 47 in 2032?

3. Can you write a query that converts UTC timestamps to various time zones while accounting for Daylight Savings in Seattle four years from now?

Those three questions may seem trivial, but there is nothing trivial about the complexity of dates and times in your data tables and reports. Learn to work with dates and times and make your boss happy.

In this demo-heavy presentation, we will answer the following questions and more:

1. When to use DATETIME and DATETIME2 and why.
2. How to make SQL Server run faster when filtering date ranges?
3. How language and date formatting affect EVERYTHING.
4. The best way to work with functions relating to the current date and time.
5. How to properly use SWITCHOFFSET, TODATETIMEOFFSET, and AT TIME ZONE Functions.

So stop wasting time and get on board because it’s about time for the plane to depart.