Received: from fido.inet-interactif.com (fido.inet-interactif.com
	[216.218.2.225])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f26JIGx60266;
	Tue, 6 Mar 2001 14:18:16 -0500 (EST)
	(envelope-from boulat@inet-interactif.com)
Received: from inet-interactif.com ([216.218.2.229])
	by fido.inet-interactif.com (8.9.3/8.9.3) with ESMTP id OAA44211;
	Tue, 6 Mar 2001 14:18:11 -0500 (EST)
	(envelope-from boulat@inet-interactif.com)
Message-ID: <3AA5385F.F308159D@inet-interactif.com>
Date: Tue, 06 Mar 2001 14:19:59 -0500
From: Boulat Khakimov <boulat@inet-interactif.com>
Organization: Inet Interactif Inc.
X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.2.18 i686)
X-Accept-Language: en
MIME-Version: 1.0
To: pgsql-sql@postgresql.org, psql-novice@postgresql.org,
	pgsql-general@postgresql.org
Subject: Date question
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200103/277
X-Sequence-Number: 5760

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