title: The difference between two dates in Hiveql
body: <p>I wish to find the differences between two dates in <strong>date format</strong> in Hiveql. I used the blow function in SAS to return a date value by subtracting a number </p>
  
  <pre><code>intnx('day', 20MAR2019 , -7)
  </code></pre>
  
  <p>It subtracts 7 days from the date and returns 13MAR2019</p>
  
  <p>I wish to convert it to Hiveql language. Any tips would be appreciated! </p>