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, rounded down to the lowest minute. 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.

Here is the current query:

```
select * from callhistory where created>date_trunc('minute', timestamp (current_timestamp-interval '5' minute));

```

It doesn't return anything. Also, the format of the created field is "2011-05-18 18:11:32.024."

Any help would be appreciated.