title: Pyspark-SQL Sum Integer to Date (with sql)
body: <p>I want to add any number of days to a given date, for example I want to add a day to today's date.</p>
  <p>I have one dataframe like this:</p>
  <pre><code>------------
  |   date   |
  ------------
  |2020-10-01|
  ------------
  </code></pre>
  <p>I would like to get a dataframe like this:</p>
  <pre><code>------------
  |   date   |
  ------------
  |2020-10-02|
  ------------
  </code></pre>
  <p>The real code is incrusted in a complex sql query then the valid result is ONLY with SQL statements.</p>
  <p>I have tried with this code, that try to get the next day of today and it's not working due to difference between types date and int, I think that I am looking for something similar to python timedelta but in pyspark-sql</p>
  <pre><code>spark.sql(f&quot;SELECT to_date(now()) + 1&quot;)
  </code></pre>
  <p>The error:</p>
  <pre><code>cannot resolve '(to_date(current_timestamp()) + 1)' due to data type mismatch: differing types in '(to_date(current_timestamp()) + 1)' (date and int)
  </code></pre>