[ https://issues.apache.org/jira/browse/SPARK-38341?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17773137#comment-17773137 ]
Lionel Cao commented on SPARK-38341: ------------------------------------ Hi, anyone can explain the behavior changing here? In spark 2, add_months returns the last day of month if the origin date is the last day of month while it changed in spark 3. I searched the definition of add_months function in some other database/dataware house products and they all have the same behavior like spark2. > Spark sql: 3.2.1 - Function of add_ Months returns an incorrect date > -------------------------------------------------------------------- > > Key: SPARK-38341 > URL: https://issues.apache.org/jira/browse/SPARK-38341 > Project: Spark > Issue Type: Bug > Components: SQL > Affects Versions: 3.2.1 > Reporter: davon.cao > Priority: Major > > Step to reproduce: > Version of spark sql: 3.2.1(latest version in maven repository) > Run sql: > spark.sql("""SELECT ADD_MONTHS(last_day('2020-06-30'), -1)""").toPandas() > expect: 2020-05-31 > actual: 2020-05-30 (x) > > Version of spark sql: 2.4.3 > spark.sql("""SELECT ADD_MONTHS(last_day('2020-06-30'), -1)""").toPandas() > expect: 2020-05-31 > actual: 2020-05-31 (/) > -- This message was sent by Atlassian Jira (v8.20.10#820010) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org