title: is there any pyspark function for add next month like DATE_ADD(date, month(int type))
body: <p>I am new in spark , is there any built in function which will show next month date from current date like today is 27-12-2016 then the function will return 27-01-2017. i have used date_add() but no function for  adding  month. I have tried date_add(date, 31)but what if the month has 30 days .</p>
  
  <pre><code>spark.sql("select date_add(current_date(),31)") .show()
  </code></pre>
  
  <p>could anyone help me about this problem. do i need to write custom function for that ? cause i didn't find any built in code still
  Thanks in advance
  Kalyan</p>