Re: [BUGS] Date calc bug

Thomas Lockhart <lockhart@alumni.caltech.edu>

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

Attachments

> 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

-- 
Thomas Lockhart				lockhart@alumni.caltech.edu
South Pasadena, California