rodeored <in...@reenie.org> writes: > On Jun 11, 10:14 am, rodeored <in...@reenie.org> wrote: >> SELECT INTERVAL '1' MONTH = 00:00:00
> Never mind, > its > SELECT NOW(),NOW()- INTERVAL '1 MONTH' as onemonthago Just for completeness --- the INTERVAL '1' MONTH syntax is supported as of 8.4. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general