title: Spark SQL datediff in seconds
body: <p>I've got following code:</p>
  
  <pre><code>table.select(datediff(table.col("Start Time"), table.col("End Time"))).show()
  </code></pre>
  
  <blockquote>
    <p>Date format is <em>2016-05-19 09:23:28 (<code>YYYY-MM-DD HH:mm:SS</code>)</em></p>
  </blockquote>
  
  <p>Function <strong>datediff</strong> calculate the difference in days. But I would like to have the difference in seconds.</p>