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