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