Handling Time Zones and Daylight Saving Time in SQL Server

preview_player
Показать описание
Working with different time zones and daylight saving time with SQL Server *can* be pretty easy with AT TIME ZONE...if you set your data up correctly. In this video we talk about the time zone of various data types and how to make sure your AT TIME ZONE conversions work as expected.

Related blog post with example code:

Follow me on Twitter:
  1. Bert Wagner
  2. SQL Server
  3. SQL
  4. AT TIME ZONE
  5. time zones
  6. datetime
Рекомендации по теме
Handling Time Zones 0:04:13

Handling Time Zones and Daylight Saving Time in SQL Server

Just store UTC? 0:07:44

Just store UTC? Handling Time Zones & Daylight Saving

The Problem with 0:10:13

The Problem with Time & Timezones - Computerphile

Time annoyances: CDT 0:00:59

Time annoyances: CDT vs CST, Too many time zones, and daylight savings time. #4dengineer

Handling Date & 0:14:08

Handling Date & Time in R | Time Zones & Daylight Savings | R Training | Rsquared Academy

The Secret to 0:27:59

The Secret to Handling Timezones with Node and MySQL Correctly

Daylight Saving Time 0:06:30

Daylight Saving Time Explained

Handling Dates and 0:09:55

Handling Dates and Times in PostgreSQL Like a Hero

Strangest Time Zones 0:08:24

Strangest Time Zones of the World #science #sciencefacts #time #timezone

How to handle 0:21:21

How to handle timezones with JavaScript | Coding with Nylas | Episode 21

#91 Pandas (Part 0:07:19

#91 Pandas (Part 68): Intuition Timezone, pytz, dateutil, Daylight Saving Time | Tutorial

Time Zones and 0:10:54

Time Zones and the Coordinated Universal Time

Lebanon Daylight Saving 0:00:33

Lebanon Daylight Saving Time Issue

John Dalziel: A 0:27:07

John Dalziel: A brief history of Time Zones and Daylight Saving Time

Handling Multiple Timezones 0:13:55

Handling Multiple Timezones in Python

Earth Science - 0:05:20

Earth Science - Understanding Time Zones

Time zone conversions 0:02:57

Time zone conversions with SQL Server's AT TIME ZONE

Time Zone and 0:11:50

Time Zone and Daylight Saving Time Issues in Astrology

Talk - Benjamin 0:26:12

Talk - Benjamin 'Zags' Zagorsky: Handling Timezones in Python

Outlook / Microsoft 0:01:05

Outlook / Microsoft Teams Timezones Offset After Daylight Savings Time Change

Time Zone Calculations 0:08:42

Time Zone Calculations

Daylight Savings Time 0:03:17

Daylight Savings Time in Mexico: EXPLAINED

Java Time and 0:24:03

Java Time and Timezone Conversion in Distributed Restful API

US Daylight Savings 0:03:01

US Daylight Savings Time & Timezone conversion to Manila time | Work from Home Terminologies #2

Комментарии
Автор

This is a great channel! I was trying to find a good explanation on this weeks ago and couldn't anywhere. I thought for sure I was doing something wrong when I had to do at time zone twice.

AdamMarcus
Автор

AWESOME the only simple explanation of this I could find, exactly what I needed, thanks.

DigitalNomadOnFIRE
Автор

Thanks Bert! First time i've seen a use case for the datetimeoffset datatype.

Reitseschaatser
Автор

Pretty good videos greatly professional.

cgovea
Автор

That was the reason to store time in UTC.... regardless of client accessing the database...

stefanotorelli
Автор

Did you intend that the two datetime values were only different by one minute?  If so, I think your second datetime value should have been on March 10, instead of the March 19 you have in the video.

LarryZing
Автор

how do you calculate the offset? I mean, how can I convert this 2022-05-01 10:00:00 -05:00 into 2022-05-01 05:00:00 ??

ChrisCollao
Автор

i have 5 databases with same tables but different name, one table called company_tbl, how to show database name and company_name from company_table

robinb
Автор

Its not working, both dates showing Same.
E. Australia Standard Time

qqqpk