HomeНаука и техникаRelated VideosMore From: LearnItFirst.com

Overview of SQL Server Data Types: Time Zone Aware Dates

23 ratings | 5682 views
This video is part of LearnItFirst's Transact-SQL Programming: SQL Server 2008/R2 course. More information on this video and course is available here: http://www.learnitfirst.com/Course161 In the last video, you looked at a mixture of old and new temporal data types. In this video, Scott focuses on DATETIME2 and DATETIMEOFFSET. He will start by reviewing some date/time commands and introducing some new ones, and you will see some important things to keep in mind when using a DATETIMEOFFSET data type. What is the disadvantage of using the DATEADD function instead of the SWITCHOFFSET function? Highlights from this video: - What command returns the UTC date? - The SYSDATETIME function - What is the advantage of using DATETIME2? - How do you get a time zone aware version of DATETIME2? - Changing the time zone and much more...
Html code for embedding videos on your blog
Text Comments (2)
Mary K (5 months ago)
Near the end of the video, you started to show that DATEADD would not return all 7 decimal places for the date you were calculating. However, it did, even though the screen tip that flashed showed that DATEADD would return smalldatetime. Why is that?
RileySRies (6 months ago)
Great video. How does it account for daylight savings though? My offsets may change from 1 to 2 hours from UTC.

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.