Overview of SQL Server Data Types: Time Zone Aware Dates

Hi i need how can we get data from GMT -1440/1440 in MS SQL
(current_timestamp at time zone 'GMT standard time'-1440/1440)

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?

Great video. How does it account for daylight savings though? My offsets may change from 1 to 2 hours from UTC.