title: Get a previous date from current date in Druid SQL
body: <p>How to get the date 7 days before from the current date in Druid SQL? I have done similar in Postgres SQL as</p>
  <pre><code>CURRENT_DATE - interval '7 day'
  </code></pre>
  <p>I need to do the same in Druid SQL query</p>