🤯 TIL MySQL is aware of daylight savings time, and considers any times between 2am-3am when the clocks skip forward an invalid date! In one session, it might throw an error, and in another session, it might store 3:00am instead of 2:05! 🤯
4
2
1
20
Thanks for the example. I’m writing a blog post about the hidden costs of DST changes
2
2
Replying to @ajturner
Nice, I look forward to reading it!

Mar 12, 2023 · 7:53 PM UTC

1
Replying to @aaronpk
Posted!
Andrew Turner (@ajturner@nullisland.social) @ajturner
Mar 13
Most people across the U.S. lost an hour of sleep last weekend. While the reason is the simple “spring forward” to Daylight Saving Time (DST), there are also significant hidden costs to time changes which should make us all lose more sleep. 1/n