Re: subtracting minutes from date

On Thu, Feb 23, 2006 at 13:55:34 -0600,
Brandon Metcalf <bmetcalf(at)nortel(dot)com> 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;