Timeline for How can I get the correct offset between UTC and local times for a date that is before or after DST?
Current License: CC BY-SA 4.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 26, 2020 at 15:21 | comment | added | LeBleu | This does not work in SQL Server 2005 as requested, in fact I don't believe AT TIME ZONE is available until SQL Server 2016. I believe in SQL Server 2016 you wouldn't want to calculate the offset and use dateadd(), just use AT TIME ZONE directly. | |
| Jun 25, 2018 at 14:08 | review | Late answers | |||
| Jun 25, 2018 at 14:12 | |||||
| Jun 25, 2018 at 13:53 | review | First posts | |||
| Jun 25, 2018 at 14:04 | |||||
| Jun 25, 2018 at 13:51 | comment | added | LowlyDBA - John M | Hi Joost! Thanks for posting. If you add some explanation to your answer, it may prove to be a lot easier to understand. | |
| Jun 25, 2018 at 13:50 | history | edited | LowlyDBA - John M | CC BY-SA 4.0 |
Formatting
|
| Jun 25, 2018 at 13:48 | history | answered | Joost Versteegen | CC BY-SA 4.0 |