title: PostgreSQL: Obtain rows from table from 5 minutes ago
body: <p>I need to obtain from the following example table all the rows that match the exactly 5 minutes ago since the query is run.</p>
  
  <p>The query will be scheduled to run every 5 minutes to get all the rows that were created in that range of time.</p>
  
  <pre><code>CREATE TABLE mytable
  (
      date timestamp without time zone NOT NULL,
      id numeric(8)
  )
  </code></pre>
  
  <p>I've tried with the interval option but because my table has the column defined as <code>timestamp without time zone</code> I'm not getting the proper info that I need.</p>