Re: Add a month

Поиск
Список
Период
Сортировка
От Gaetano Mendola
Тема Re: Add a month
Дата
Msg-id 00a801c1f5a5$10d79f60$d5a9fea9@GMENDOLA2
обсуждение исходный текст
Ответ на Add a month  ("Gaetano Mendola" <mendola@bigfoot.com>)
Список pgsql-admin
From: "Rajesh Kumar Mallah." <mallah@trade-india.com>
> Hi the answer is:
>
> select now() + cast  ( '1 day' as interval ) ;

I guess that for me should be enough

cast ('1 month' as interval)
or may be after RTFM

should be also good

select now() + interval '1 month';

> are you reading  manuals ??

of course before to ask I give a look at manuals
but I was looking:

paragraph 3.5 and Appendix A of User's Guide  ===> nothing

after searching 'cast' on all document I find that was on
paragraph 4.8 my answer but may was good put a
link from 3.5 to 4.8 ?

Ciao
Gaetano.


В списке pgsql-admin по дате отправления:

Предыдущее
От: "Rajesh Kumar Mallah."
Дата:
Сообщение: Re: Add a month
Следующее
От: "Gaetano Mendola"
Дата:
Сообщение: Re: Delete function