Horton
Menu

Re: Date question

Peter Eisentraut <peter_e@gmx.net>

View thread
From: Peter Eisentraut <peter_e@gmx.net>
To: Boulat Khakimov <boulat@inet-interactif.com>
Cc: <pgsql-sql@postgresql.org>, <psql-novice@postgresql.org>, <pgsql-general@postgresql.org>
Date: 2001-03-06T19:40:25Z
Lists: pgsql-general 
Boulat Khakimov writes:

> 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.

How about CURRENT_DATE + INTERVAL '12 months'?

-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/