Re: Porting from Oracl to Postgres - Mailing list 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