| From: | Rod Taylor <rbt(at)rbt(dot)ca> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Casey Allen Shobe <cshobe(at)secureworks(dot)net>, pgsql-bugs(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Postgres storing time in strange manner |
| Date: | 2002-09-15 14:51:34 |
| Message-ID: | 1032101495.19130.29.camel@jester |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-novice |
On Sun, 2002-09-15 at 10:32, Tom Lane wrote:
> > On Sunday 15 September 2002 10:11 am, Rod Taylor wrote:
> >> On Sun, 2002-09-15 at 03:57, Casey Allen Shobe wrote:
> >>> I don't have a clue why it's doing this - has anyone else seen this sort
> >>> of behavior, or know why it might be doing it? It shows times wrong, for
> >>> instance, it shows 00:04:60 where it should show 00:05:00. See below:
> >>
> >> There are actually 61 seconds in some minutes. In order to accommodate
> >> leap seconds, PostgreSQL allows this to happen -- similarly to how it
> >> will also allow 366 days in some years.
>
> True but irrelevant -- PG does not do accounting for leap seconds.
For some reason I thought it did accommodate it when I was still using
7.1.
Ahh well, if the bug is fixed, then it's all good.
--
Rod Taylor
| From | Date | Subject | |
|---|---|---|---|
| Next Message | pgsql-bugs | 2002-09-15 15:12:03 | Bug #768: Wrong special characters handling in Java |
| Previous Message | Rod Taylor | 2002-09-15 14:49:22 | Re: Postgres storing time in strange manner |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-09-15 15:07:55 | Re: Deep quotation |
| Previous Message | Rod Taylor | 2002-09-15 14:49:22 | Re: Postgres storing time in strange manner |