Re: Postgres storing time in strange manner - Mailing list pgsql-bugs

From Rod Taylor
Subject Re: Postgres storing time in strange manner
Date
Msg-id 1032101495.19130.29.camel@jester
Whole thread Raw
In response to Re: Postgres storing time in strange manner  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
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


pgsql-bugs by date:

Previous
From: Rod Taylor
Date:
Subject: Re: Postgres storing time in strange manner
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #768: Wrong special characters handling in Java