title: PostgreSQL query - return all results with field with past 5 minutes
body: <p>Hey everyone. Here is my situation... I need to craft a sql query against a postgresql server that will return all records created within the past 5 minutes, <em>rounded down to the lowest minute</em>. So if cron kicks the query off at 12:05:25.000, it needs to query all records created since 12:00:00.000. So I guess I really have two issues.</p>
  
  <ul>
  <li><p>I know using </p>
  
  <p>DATE_SUB(now(),INTERVAL
     5 MINUTE)</p>
  
  <p>works in mysql - is there
  an equivalent in postgresql? I
  couldn't find any mention of it in
  the date/time functions documentation
  <a href="http://www.postgresql.org/docs/8.2/static/functions-datetime.html" rel="nofollow">here</a>.</p></li>
  <li><p>Second, how do I tell it to round
  down to the minute (ignore seconds)
  for the 5 minute interval?</p></li>
  </ul>
  
  <p>Any advice would be appreciated.</p>