Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-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

pgsql-novice by date

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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group