On 4/26/2017 1:30 PM, Pietro Pugni wrote:Adding 10 years to 1912-02-29 returns 1922-02-29, as expected.I would like to apply the reverse operation. To do so, I subtract 10 years from 1922-02-29 but I obtain 1912-02-28, so the math is actually wrong.assuming 1922 was a leap year, 1912 is NOT a leap year, so therefore there is no 1912-02-29, that is an invalid date.
Adding 10 years to 1912-02-29 returns 1922-02-29, as expected.I would like to apply the reverse operation. To do so, I subtract 10 years from 1922-02-29 but I obtain 1912-02-28, so the math is actually wrong.
assuming 1922 was a leap year, 1912 is NOT a leap year, so therefore there is no 1912-02-29, that is an invalid date.
pgsql-bugs by date:
Соглашаюсь с условиями обработки персональных данных