Re: interval is ignored

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: rodeored <info1(at)reenie(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: interval is ignored
Date: 2009-06-15 19:55:19
Message-ID: 23628.1245095719@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Wilson 2009-06-15 20:06:16 Re: Select ranges based on sequential breaks
Previous Message James B. Byrne 2009-06-15 19:16:18 Re: cygwin and postgresql