Horton
Menu

Date question

Boulat Khakimov <boulat@inet-interactif.com>

View thread
From: Boulat Khakimov <boulat@inet-interactif.com>
To: pgsql-sql@postgresql.org, psql-novice@postgresql.org, pgsql-general@postgresql.org
Date: 2001-03-06T19:19:59Z
Lists: pgsql-general 
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