Re: Date Math

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Date Math
Date: 2007-05-07 17:23:23
Message-ID: Pine.LNX.4.64.0705071022520.20021@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 7 May 2007, A. Kretschmer wrote:

> I think, you should cast your intervals, an example:
>
> select current_date + '10 months'::interval;

Andreas,

OK. I wasn't clear on this point.

Thanks,

Rich

--
Richard B. Shepard, Ph.D. | The Environmental Permitting
Applied Ecosystem Services, Inc. | Accelerator(TM)
<http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2007-05-07 17:30:30 Re: Date Math
Previous Message Magnus Hagander 2007-05-07 17:14:50 Re: pg_ctl: could not start service "pgsql-8.2": error code 1063