Re: subtracting minutes from date - Mailing list pgsql-general

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