January 3, 2009 at 21:48

In a year

    Maybe this is correct, but somehow unexpectedly. UPD Based on the discussion, I summarize: a) this is the standard behavior of other DBMSs 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




    Tags:

    Also popular now: