[ https://issues.apache.org/jira/browse/SPARK-30740?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
nhufas updated SPARK-30740: --------------------------- Description: months_between not calculating right for February example {{select }} {{ months_between('2020-02-29','2019-12-29')}} {{,months_between('2020-02-29','2019-12-30') }} {{,months_between('2020-02-29','2019-12-31') }} will generate a result like this |2|1.96774194|2| For 2019-12-30 is calculating wrong. was: months_between not calculating right for February example !image-2020-02-05-18-40-34-600.png! > months_between wrong calculation > -------------------------------- > > Key: SPARK-30740 > URL: https://issues.apache.org/jira/browse/SPARK-30740 > Project: Spark > Issue Type: Bug > Components: SQL > Affects Versions: 2.4.4 > Reporter: nhufas > Priority: Critical > > months_between not calculating right for February > example > > {{select }} > {{ months_between('2020-02-29','2019-12-29')}} > {{,months_between('2020-02-29','2019-12-30') }} > {{,months_between('2020-02-29','2019-12-31') }} > > will generate a result like this > |2|1.96774194|2| > > For 2019-12-30 is calculating wrong. > > > -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org