Overview of SQL Server Data Types: Time Zone Aware Dates

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/Course/161/SQL-Programming-2008.aspx?an=YouTube

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

Category:

Science & Technology

Tags:

• t-sql
• temporal data type
• datetime
• datetime2
• datetimeoffset
• date time command
• dateadd
• switchoffset
• utc date
• sysdatetime
• function
• time zone

[hassax1966]

God bless you !!

[abdulhkhan]

Hi There wondering if you can help with my query. I am trying to get the current date but nothing seems to work unless I specify the date myself, please see below query, appreciate any help.

SELECT UNIQUE last_name, reader_desc,xact_date,xact_tim­e

FROM badge_history

WHERE xact_date="20111206" AND

(badge_history.reader_desc="DO­OR 1"

OR

badge_history.reader_desc="DOO­R 2")

ORDER 1,4