🤯 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! 🤯

Mar 12, 2023 Ā· 3:08 AM UTC

4
2
1
20
omfg, TIMESTAMP type columns are timezone-aware, but DATETIME columns are always UTC. How have I been using MySQL for 25 years and never known this dev.mysql.com/doc/refman/8.0…
3
14
Replying to @aaronpk
Thanks for the example. I’m writing a blog post about the hidden costs of DST changes
2
2
Nice, I look forward to reading it!
1
Replying to @aaronpk
Database is closed, try again in the morning.
1