Re: Porting from Oracl to Postgres - Mailing list pgsql-sql

From Rod Taylor
Subject Re: Porting from Oracl to Postgres
Date
Msg-id 1062770250.66151.9.camel@jester
Whole thread Raw
In response to Porting from Oracl to Postgres  (Jomon Skariah <jomons@aztec.soft.net>)
Responses Re: Porting from Oracl to Postgres
List pgsql-sql
On Fri, 2003-09-05 at 00: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..

Guessing based on the name that it adds a quantity of months to a
timestamp.  How about an SQL Interval?

now() + interval '15 months'

List of functions:
http://www.postgresql.org/docs/7.3/interactive/functions.html


pgsql-sql by date:

Previous
From: "Yaroslav Ulyanov"
Date:
Subject: Transactions ID
Next
From: Richard Huxton
Date:
Subject: Re: Porting from Oracl to Postgres