SELECT INTERVAL '1' MONTH = 00:00:00 Therefore now=onemonthagoSELECT NOW(),NOW()- INTERVAL '1' MONTH as onemonthago
How do I get the timestamp for one month ago?