On Jun 11, 10:14 am, rodeored <in(dot)(dot)(dot)(at)reenie(dot)org> 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