interval '1 month'incorporate month differences and leap years when calculating date/datetime boundaries? If so, how does it work?
I was asked this question, and I'm not sure how to answer it. I am using Postgres as a reference example, I assume it has its own time offset and calculation integration. But how does this take into account timezones, leap years, and other oddities of the calendaring?
I want to know if there's anything in a the SQL spec that defines how the behavior will occur.