SQL doubt - Date Add

From: sreejith s <getsreejith(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: SQL doubt - Date Add
Date: 2004-10-10 14:19:57
Message-ID: 5d14ecf904101007197d0acbbf@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Gaetano Mendola 2004-10-10 14:36:54 Re: SQL doubt - Date Add
Previous Message Marc G. Fournier 2004-10-10 13:01:17 Re: How do FKs work?