Aleksander Kmetec <aleksander(dot)kmetec(at)intera(dot)si> writes:
> You can do something like this:
> test=> select NOW() - '1 month'::interval;
> ?column?
> -------------------------------
> 2004-10-17 12:31:09.944818+02
Also, depending on just what you meant by "previous month", you might
want to apply date_trunc():
regression=# select date_trunc('month', NOW()) - '1 month'::interval;
?column?
------------------------
2004-10-01 00:00:00-04
(1 row)
regards, tom lane