Horton
Menu

Re: [SQL] Date question

Michael Fork <mfork@toledolink.com>

View thread
From: Michael Fork <mfork@toledolink.com>
To: Boulat Khakimov <boulat@inet-interactif.com>
Cc: pgsql-sql@postgresql.org, psql-novice@postgresql.org, pgsql-general@postgresql.org
Date: 2001-03-06T19:26:58Z
Lists: pgsql-general 
This will do it:

mfork=# SELECT to_char(now() + '1 Year'::interval, 'YYYY-MM-DD');   
  to_char   
------------
 2002-03-06
(1 row)

Michael Fork - CCNA - MCP - A+
Network Support - Toledo Internet Access - Toledo Ohio

On Tue, 6 Mar 2001, Boulat Khakimov wrote:

> Hi,
> 
> Im a little bit stuck here.
> 
> Does anyone know how to get date in format 'YYYY-MM-DD' of a date one
> year from now.
> So for example today is '2001-03-06' I need to get date 12 months from
> now
> which will be '2002-03-06' in todays case...
> 
> In mysql I used  DATE_ADD(CURDATE(), INTERVAL 12 MONTH) , but that
> doesnt work in PG.
> 
> 
> Regards,
> Boulat Khakimov
> 
> 
> -- 
> Nothing Like the Sun
>