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