| 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 |