title: How to subtract seconds from current timestamp
body: <p>I'm trying to create a query which will get the results that were inserted in the last 10 seconds:</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT *
    FROM table
    WHERE client_id = 1
      AND hash = 'x'
      AND insert_time &gt;= current_timestamp - **10 seconds**
  </code></pre>
  
  <p>I've been searching how to subtract 10 seconds from the current timestamp, but I didn't succeed yet.</p>