Re: SQL doubt - Date Add

sreejith s wrote:
> Hi friends,
>               I problem is i want to add a specified no. of years to a
> given date
> ie, 12/12/2004 + 5 = 12/12/2009. This has to be done via sql. Any 
> predefined function there for the same. or v have split the yr and
> then add.
> Sreejith
>

# select '2004-12-12'::date + 5 * '1 year'::interval;      ?column?
--------------------- 2009-12-12 00:00:00
(1 row)



Regards
Gaetano Mendola