title: How to get TIMESTAMP of 15 minutes ago using BigQuery?
body: <p>Found <a href="https://stackoverflow.com/questions/33436494/get-data-that-is-no-more-than-an-hour-old-in-bigquery">this</a> but this doesn't run on standard SQL</p>
  
  <p>I tried to do:</p>
  
  <pre><code>WHERE datew &gt; DATE_SUB(CURRENT_TIMESTAMP(),INTERVAL 5 DAY )
  </code></pre>
  
  <p>But this doesn't work. According to the docs <code>DATE_SUB</code> supports only</p>
  
  <pre><code>DAY
  WEEK. Equivalent to 7 DAYs.
  MONTH
  QUARTER
  YEAR
  </code></pre>
  
  <p>How can I get current <code>time stamp - 15 minutes</code> on standard SQL with BigQuery?</p>