From: "Rajesh Kumar Mallah." <[EMAIL PROTECTED]>
> 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.


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Reply via email to