Re: [BUGS] Postgres storing time in strange manner

From: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
To: PgSQL Novice ML <pgsql-novice(at)postgresql(dot)org>
Subject: Re: [BUGS] Postgres storing time in strange manner
Date: 2002-09-17 00:56:42
Message-ID: 1032224202.25231.11.camel@haggis
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-novice

On Sun, 2002-09-15 at 09:51, Rod Taylor wrote:
> 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.

In a subsequent post, Tom Lane said that 7.2.2 fixed the problem,
but a reply post from the original poster says that he is, in fact,
using 7.2.2...

--
+-----------------------------------------------------------------+
| Ron Johnson, Jr. Home: ron(dot)l(dot)johnson(at)cox(dot)net |
| Jefferson, LA USA |
| |
| "I'm not a vegetarian because I love animals, I'm a vegetarian |
| because I hate vegetables!" |
| unknown |
+-----------------------------------------------------------------+

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2002-09-17 05:15:30 Re: [BUGS] Postgres storing time in strange manner
Previous Message Neil Conway 2002-09-17 00:45:33 Re: Bug #758: show_planner_stats does not work for new PREPARE calls

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2002-09-17 05:15:30 Re: [BUGS] Postgres storing time in strange manner
Previous Message Peter Eisentraut 2002-09-16 23:08:04 Re: Postgres storing time in strange manner