title: How to pick yesterday date in spark sql for a date in Unix Date Format?
body: <p>How to pick yesterday date in spark sql for a date in Unix Date Format? Example : Select * from **** where date in (DateinUnixFormat)</p>
  <p>Please help.</p>