Re: SQL and function reference? - Mailing list pgsql-novice

Alexander Borkowski <alexander.borkowski@abri.une.edu.au> writes:
> How about:

> select *
> from flights
> where date < cast(current_date + interval '30 days ago' as date);

This is the hard way ... you can just add/subtract a date and an
integer, instead:

  ... where date < (current_date - 30);

            regards, tom lane