title: Presto: how to specify time interval using the current date and timezone
body: <p>How to rewrite the following query:</p>
  
  <pre class="lang-sql prettyprint-override"><code>WHERE (
      parsedTime BETWEEN 
      TIMESTAMP '2019-10-29 00:00:00 America/New_York' AND
      TIMESTAMP '2019-11-11 23:59:59 America/New_York'
  ) 
  </code></pre>
  
  <p>but making the interval dynamic: from 14 days ago to <code>current_date</code>?</p>