[ https://issues.apache.org/jira/browse/SPARK-38341?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
davon.cao updated SPARK-38341: ------------------------------ Component/s: SQL (was: Spark Submit) > 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.1#820001) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org