logoalt Hacker News

layer8 • today at 10:01 AM • 1 reply • view on HN

> Adding a month with + INTERVAL '1 months' is timezone-dependent. […]

Adding months isn’t well-defined anyway, even when using date, for days of month > 28. I think it’s a mistake that systems generically allow such a computation (as opposed to application code implementing domain-specific business rules).


Replies

cryptonector • today at 5:06 PM

D. Richard Hipp had a great blog about this on sqlite.org quite a while back.

➕ show 1 reply