Re: [BUGS] Date calc bug

ohp@pyrenet.fr

From: Olivier PRENANT <ohp@pyrenet.fr>
To: Thomas Lockhart <lockhart@alumni.caltech.edu>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Tulassay Zsolt <zsolt@tek.bke.hu>, pgsql-hackers@postgreSQL.org
Date: 2000-01-04T18:07:38Z
Lists: pgsql-bugs, pgsql-hackers

Attachments

Thanks you!!

Patch applied and tested.

Great job.

That's exactly the reason why I love Internet and postresql.

You find a bug.. Send a message and correct it.

Best wishes for 2000.

Regards

On Tue, 4 Jan 2000, Thomas Lockhart wrote:

> > forum=> select datetime(now())+'74565 days'::timespan as ido;
> > Thu Jan 19 14:07:30 2068
> and
> > select '12-01-1999'::datetime + '@ 1 month - 1 sec' ;
> > Thu Dec 30 23:59:59 1999 EST
> 
> I've repaired both problems in both the development and release trees.
> Thanks for the reports and analysis. Patch enclosed...
> 
>                       - Thomas
> 
> 

-- 
Olivier PRENANT         	Tel:	+33-5-61-50-97-00 (Work)
Quartier d'Harraud Turrou           +33-5-61-50-97-01 (Fax)
31190 AUTERIVE                      +33-6-07-63-80-64 (GSM)
FRANCE                      Email: ohp@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)