On Jun 11, 10:14 am, rodeored <[email protected]> wrote: > SELECT INTERVAL '1' MONTH = 00:00:00 > Therefore now=onemonthago > SELECT NOW(),NOW()- INTERVAL '1' MONTH as onemonthago > > How do I get the timestamp for one month ago?
Never mind, its SELECT NOW(),NOW()- INTERVAL '1 MONTH' as onemonthago -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
