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