Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-2086

Incorrect handling of leap years when adding 1 year interval to date

    XMLWordPrintableJSON

    Details

      Description

      Impala returns incorrect result when the following query is executed:

      select CAST('2011-02-28 00:00:00' as TIMESTAMP) + INTERVAL '1' YEAR as stamp;
      

      Impala result:

      2012-02-29 00:00:00 
      

      Postgres result:

      2012-02-28 00:00:00
      

        Attachments

          Activity

            People

            • Assignee:
              caseyc casey
              Reporter:
              tarasbob Taras Bobrovytsky
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: