> A number of New Zealand petrol pumps stopped working on Thursday due to a "leap year glitch" in payment software, fuel stations and the payment service provider said.
https://www.reuters.com/world/asia-pacific/leap-year-glitch-...
https://www.reuters.com/world/asia-pacific/leap-year-glitch-...
Self-pay gas station pumps break across NZ as software can't handle Leap Day - https://news.ycombinator.com/item?id=39553755 - Feb 2024 (31 comments)
Old programmer rant: In my day, we fixed the Y2K bug - we went to the future and back several times a day!
But then, come to think of it, you don't need to use SQL to have good date logic. C# and Java both have excellent date handing libraries. I don't know about C++, but I'd be surprised if there was not a modern date library for C++, so I am of the opinion there should be no excuses for software not to work on the 29th of Feb.
Use date handling functions and libraries that have been developed by people who know how to do it and have been battle tested.
The standard library now includes <chrono>. AFAIK: It was mostly written by Howard Hinnant. He now has more date/time libs that expand upon <chrono>: https://github.com/HowardHinnant/date