𤯠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



