The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/functions-datetime.html
Description:
Dear PostgreSQL Developers,
I have encountered a potential issue with the interval calculation when
adding 1 year to a non-leap year. The behavior observed is that when adding
1 year to a date in a non-leap year such as 2023, the resulting date is
incorrectly set to February 28th instead of February 29th in the following
leap year, which should be 2024.
This behavior is inconsistent with the expected behavior, as it does not
account for leap years when performing date arithmetic using intervals.
Please find below a sample query illustrating the issue:
SELECT ('2023-02-28 23:59:59')::timestamp + INTERVAL '1 year';
Expected result: '2024-02-29 23:59:59'
Actual result: '2024-02-28 23:59:59'
This issue could potentially impact applications relying on accurate date
arithmetic, particularly in scenarios involving financial calculations or
date projections.
Thank you for your attention to this matter.
Sincerely,
Mohamed Riyazath
mdriyazathcse@gmail.com