Re: Add a month - Mailing list pgsql-admin

From Gaetano Mendola
Subject Re: Add a month
Date
Msg-id 00a801c1f5a5$10d79f60$d5a9fea9@GMENDOLA2
Whole thread Raw
In response to Add a month  ("Gaetano Mendola" <mendola@bigfoot.com>)
List 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 by date:

Previous
From: "Rajesh Kumar Mallah."
Date:
Subject: Re: Add a month
Next
From: "Gaetano Mendola"
Date:
Subject: Re: Delete function