Re: Porting from Oracl to Postgres

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: Jomon Skariah <jomons(at)aztec(dot)soft(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Porting from Oracl to Postgres
Date: 2003-09-05 13:57:31
Message-ID: 1062770250.66151.9.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2003-09-05 14:12:04 Re: Porting from Oracl to Postgres
Previous Message Richard Huxton 2003-09-05 08:17:11 Re: Fw: Transactions ID