The following bug has been logged on the website:
Bug reference: 14632
Logged by: Pietro Pugni
Email address: pietro.pugni@gmail.com
PostgreSQL version: 9.6.2
Operating system: Ubuntu 16.04.2 LTS
Description:
The following query:SELECT '1912-02-29'::date + '10 years'::interval
returns:'1922-02-28 00:00:00'
while the reverse operation:SELECT '1922-02-28'::date - '10 years'::interval
returns:'1912-02-28 00:00:00'
instead of '1912-02-29 00:00:00'.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs