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
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 9, 2020 at 21:55 | history | edited | Hannah Vernon♦ | CC BY-SA 4.0 |
added details from comments
|
| Mar 1, 2019 at 9:38 | comment | added | Quandary | @Ludo Bernaerts: First use milliseconds, second: this does not work because the UTC offset today might be different than the UTC-offset at a certain time (daylight-saving - summer vs winter time) ... | |
| Aug 8, 2018 at 1:36 | comment | added | Eamon | Whilst I aggree this doesn't address the actual question, as far as this answer is concerned I think the following is better: SELECT DATEADD(MINUTE, DATEPART(TZoffset, SYSDATETIMEOFFSET()), @utc) | |
| Oct 17, 2017 at 13:18 | comment | added | Matt | This doesn't work as you are only determining if the current time is DST or not, then comparing a time that could be DST or not. Using your above example code and datetime in the UK currently tells me that it should be 6:14am, however November is outside DST so it should be 5:14am as GMT and UTC coincide. | |
| S Nov 20, 2014 at 9:46 | history | suggested | vijayp | CC BY-SA 3.0 |
Formatted sql query and removed Hi
|
| Nov 20, 2014 at 9:00 | review | Suggested edits | |||
| S Nov 20, 2014 at 9:46 | |||||
| Nov 20, 2014 at 8:32 | review | Late answers | |||
| Nov 20, 2014 at 9:00 | |||||
| Nov 20, 2014 at 8:20 | review | First posts | |||
| Nov 20, 2014 at 10:14 | |||||
| Nov 20, 2014 at 8:16 | history | answered | Ludo Bernaerts | CC BY-SA 3.0 |