From: | "Gaetano Mendola" <mendola(at)bigfoot(dot)com> |
---|---|
To: | "Rajesh Kumar Mallah(dot)" <mallah(at)trade-india(dot)com>, <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Add a month |
Date: | 2002-05-07 08:56:24 |
Message-ID: | 00a801c1f5a5$10d79f60$d5a9fea9@GMENDOLA2 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
From: "Rajesh Kumar Mallah." <mallah(at)trade-india(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Gaetano Mendola | 2002-05-07 10:17:59 | Re: Delete function |
Previous Message | Rajesh Kumar Mallah. | 2002-05-07 07:46:42 | Re: Add a month |