[ https://issues.apache.org/jira/browse/SPARK-30740?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17032894#comment-17032894 ]
Yuming Wang commented on SPARK-30740: ------------------------------------- cc [~maxgekk] > 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