Skip site navigation (1) Skip section navigation (2)

Re: SQL doubt - Date Add

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 (view raw or flat)
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

In response to

pgsql-sql by date

Next:From: Harald FuchsDate: 2004-10-11 09:33:55
Subject: Re: Export tab delimited from mysql to postgres.
Previous:From: Theo GalanakisDate: 2004-10-10 22:59:40
Subject: Export tab delimited from mysql to postgres.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group