Re: subtracting minutes from date

[Bruno Wolff III <bruno@xxxxxxxx>]

On Thu, Feb 23, 2006 at 13:55:34 -0600,
  Brandon Metcalf <bmetcalf@xxxxxxxxxx> wrote:
> 
> If I have a column called date with data type timestamp without time
> zone I know I can use
> 
>   SELECT * FROM table WHERE date < (now()::DATE - 7)::TIMESTAMP;

You can do this without converting to timestamp:
SELECT * FROM table WHERE date < current_date - 7;