From: | Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, ohp(at)pyrenet(dot)fr, Tulassay Zsolt <zsolt(at)tek(dot)bke(dot)hu> |
Cc: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [BUGS] Date calc bug |
Date: | 2000-01-04 08:11:32 |
Message-ID: | 3871AB34.5ACE74C7@alumni.caltech.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-hackers |
> 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(at)alumni(dot)caltech(dot)edu
South Pasadena, California
Attachment | Content-Type | Size |
---|---|---|
dt.c.patch | text/plain | 1.5 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Dirk Lutzebaeck | 2000-01-04 12:15:59 | vacuum analyze corrupts db with larger tuples (< 8k) |
Previous Message | wrobell | 2000-01-03 13:42:01 | A bug |
From | Date | Subject | |
---|---|---|---|
Next Message | Norman Widders | 2000-01-04 08:29:57 | Re: [HACKERS] Inprise/Borland releasing Interbase as Open source |
Previous Message | Thomas Lockhart | 2000-01-04 07:27:25 | Re: [HACKERS] Docs |