Обсуждение: ADD_Months Function in Postgres

Поиск
Список
Период
Сортировка

ADD_Months Function in Postgres

От
"Amin Schoeib"
Дата:

Hi,
I would like to know if there is a Function in Postgres
Like the add_months Function in Oracle??

Thanxx

Schoeib

4Tek Gesellschaft für angewandte Informationstechnologien mbH
Schoeib Amin
Tel.  +49 (0) 69 697688-132
Fax. +49 (0) 69 697688-111
http://www.4tek.de

Re: ADD_Months Function in Postgres

От
Pavel Stehule
Дата:
Hello

You can try

select current_date + interval '1 month';

regards
Pavel Stehule

On Tue, 2 Sep 2003, Amin Schoeib wrote:

> Hi,
> I would like to know if there is a Function in Postgres
> Like the add_months Function in Oracle??
>
> Thanxx
>
> Schoeib
>
> 4Tek Gesellschaft für angewandte Informationstechnologien mbH
> Schoeib Amin
> Tel.  +49 (0) 69 697688-132
> Fax. +49 (0) 69 697688-111
> http://www.4tek.de
>
>