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? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
