Re: Add a month

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.

In response to

Browse pgsql-admin by date

  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