https://issues.apache.org/jira/browse/SPARK-8185
[SPARK-8185] date/time function: datediff - ASF JIRA<https://issues.apache.org/jira/browse/SPARK-8185> issues.apache.org Spark; SPARK-8159 Improve expression function coverage (Spark 1.5) SPARK-8185; date/time function: datediff ________________________________ From: farman.bsse1855 <farman....@zigron.com> Sent: Wednesday, September 7, 2016 7:27 AM To: dev@spark.apache.org Subject: How to get 2 years prior date from currentdate using Spark Sql I need to derive 2 years prior date of current date using a query in Spark Sql. For ex : today's date is 2016-09-07. I need to get the date exactly 2 years before this date in the above format (YYYY-MM-DD). Please let me know if there are multiple approaches and which one would be better. Thanks -- View this message in context: http://apache-spark-developers-list.1001551.n3.nabble.com/How-to-get-2-years-prior-date-from-currentdate-using-Spark-Sql-tp18875.html Apache Spark Developers List - How to get 2 years prior date from currentdate using Spark Sql<http://apache-spark-developers-list.1001551.n3.nabble.com/How-to-get-2-years-prior-date-from-currentdate-using-Spark-Sql-tp18875.html> apache-spark-developers-list.1001551.n3.nabble.com How to get 2 years prior date from currentdate using Spark Sql. I need to derive 2 years prior date of current date using a query in Spark Sql. For ex : today's date is 2016-09-07. I need to get the... Sent from the Apache Spark Developers List mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe e-mail: dev-unsubscr...@spark.apache.org