From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | Gaetano Mendola <mendola(at)bigfoot(dot)com> |
Cc: | sreejith s <getsreejith(at)gmail(dot)com>, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: SQL doubt - Date Add |
Date: | 2004-10-11 09:21:31 |
Message-ID: | 416A509B.5000900@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Gaetano Mendola wrote:
> 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)
But be aware of...
richardh=# SELECT '2004-02-28'::date + '1 year'::interval;
?column?
---------------------
2005-02-28 00:00:00
(1 row)
richardh=# SELECT '2004-02-29'::date + '1 year'::interval;
?column?
---------------------
2005-02-28 00:00:00
(1 row)
richardh=# SELECT '2004-02-29'::date + '4 years'::interval;
?column?
---------------------
2008-02-29 00:00:00
(1 row)
--
Richard Huxton
Archonet Ltd
From | Date | Subject | |
---|---|---|---|
Next Message | Harald Fuchs | 2004-10-11 09:33:55 | Re: Export tab delimited from mysql to postgres. |
Previous Message | Theo Galanakis | 2004-10-10 22:59:40 | Export tab delimited from mysql to postgres. |