In a year
Maybe this is right, but somehow unexpected.
UPD Based on the results of the discussion I summarize:
a) this is the standard behavior of other DBMS and moreover
b) this method of calculating the annual period is legal and applied offline.
select
'2008-02-27' + INTERVAL 1 YEAR, -- 2009-02-27
'2008-02-28' + INTERVAL 1 YEAR, -- 2009-02-28
'2008-02-29' + INTERVAL 1 YEAR, -- 2009-02-28
'2008-03-01' + INTERVAL 1 YEAR; -- 2009-03-01
UPD Based on the results of the discussion I summarize:
a) this is the standard behavior of other DBMS and moreover
b) this method of calculating the annual period is legal and applied offline.
')
Source: https://habr.com/ru/post/48327/
All Articles