Old programmer rant: In my day, we fixed the Y2K bug - we went to the future and back several times a day!
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.
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
Use date handling functions and libraries that have been developed by people who know how to do it and have been battle tested.