Developer Advocate at 🔷Microsoft (PostgreSQL on Azure), developer-focused expertise in databases: 🐘 PostgreSQL, 🚀 YugabyteDB, 🍃 MongoDB, 🅾️ Oracle (OCM), former ♠️ACE Director and🔶AWS Data Hero
Location
Lausanne, Switzerland
Education
Master MIAGE, Université Paris-Sud, France
Work
Developer Advocate at Microsoft (PostgreSQL on Azure - Principal Product Manager)
Top comments (3)
Sure PostgreSQL can. Seems MySQL fixed it in 8.0.28: bugs.mysql.com/bug.php?id=12654
TIL. Is this a tough thing to work around if you need to date stuff way in the future for any reason?
Why not just use DATETIME format instead?
Postgres does it better (as usual :) ) and doesn't have the issue at all though, IIRC.