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-16 10:16:48
Message-ID: 1032171408.24696.18.camel@haggis
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-novice

On Sun, 2002-09-15 at 17:15, David Lloyd wrote:
>
> Casey,
>
> > > 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.
> >
> > How then, am I supposed to explain to a web interface user that when they just
> > entered 5:00:00, it's going to sometimes show up to 4:59:60?
>
> Leap minutes? Oh please. I'm gonna have to account for green martians
> next...

Well, there *are* leap minutes and leap seconds. They just happen
*so* rarely...

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

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2002-09-16 13:27:33 Re: Explicit timestamp conversion very slow
Previous Message Tom Lane 2002-09-16 04:51:21 Re: Bug #758: show_planner_stats does not work for new PREPARE calls

Browse pgsql-novice by date

  From Date Subject
Next Message Terry Yapt 2002-09-16 12:12:57 psql and readline library: cursor keys
Previous Message David Lloyd 2002-09-15 22:15:09 Re: [NOVICE] Postgres storing time in strange manner