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/