Re: Porting from Oracl to Postgres

From: Richard Huxton <dev(at)archonet(dot)com>
To: Jomon Skariah <jomons(at)aztec(dot)soft(dot)net>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Porting from Oracl to Postgres
Date: 2003-09-05 14:12:04
Message-ID: 200309051512.04518.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Friday 05 September 2003 05:24, Jomon Skariah wrote:
> Hi,
>
> Thanks for your replys.
>
> We are facing another problem now.
>
> we need to find an alternative for Oracle's ADD_MONTHS in PostGres..

SELECT now() + '1 hour'::interval;
SELECT now() + '2 days'::interval;
SELECT now() + '3 months':: interval;

See the data-types section of the manual for details.

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jeff Eckermann 2003-09-05 14:29:56 Re: Porting from Oracl to Postgres
Previous Message Rod Taylor 2003-09-05 13:57:31 Re: Porting from Oracl to Postgres