Quick Links

Date question

From:	Boulat Khakimov <boulat(at)inet-interactif(dot)com>
To:	pgsql-sql(at)postgresql(dot)org, psql-novice(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject:	Date question
Date:	2001-03-06 19:19:59
Message-ID:	3AA5385F.F308159D@inet-interactif.com
Views:	Whole Thread \| Raw Message \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general pgsql-sql

Hi,

Im a little bit stuck here.

Does anyone know how to get date in format 'YYYY-MM-DD' of a date one
year from now.
So for example today is '2001-03-06' I need to get date 12 months from
now
which will be '2002-03-06' in todays case...

In mysql I used DATE_ADD(CURDATE(), INTERVAL 12 MONTH) , but that
doesnt work in PG.

Regards,
Boulat Khakimov

--
Nothing Like the Sun

Responses

Re: [SQL] Date question at 2001-03-06 19:26:58 from Michael Fork
RE: [SQL] Date question at 2001-03-06 19:30:03 from Francis Solomon
Re: Date question at 2001-03-06 19:40:25 from Peter Eisentraut
Re: [SQL] Date question at 2001-03-06 20:02:55 from Jie Liang

Browse pgsql-general by date

	From	Date	Subject
Next Message	Mike Mascari	2001-03-06 19:23:47	RE: SQL article
Previous Message	John Burski	2001-03-06 19:09:42	Re: SQL article

Browse pgsql-sql by date

	From	Date	Subject
Next Message	Mike Mascari	2001-03-06 19:25:28	RE: Date question
Previous Message	Bruce Momjian	2001-03-06 19:04:38	Re: Quick question MySQL --> PgSQL