Re: [BUGS] Postgres storing time in strange manner - Mailing list pgsql-novice

From Ron Johnson
Subject Re: [BUGS] Postgres storing time in strange manner
Date
Msg-id 1032171408.24696.18.camel@haggis
Whole thread Raw
In response to Re: [BUGS] Postgres storing time in strange manner  (David Lloyd <lloy0076@rebel.net.au>)
List 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.l.johnson@cox.net             |
| Jefferson, LA  USA                                              |
|                                                                 |
| "I'm not a vegetarian because I love animals, I'm a vegetarian  |
|  because I hate vegetables!"                                    |
|    unknown                                                      |
+-----------------------------------------------------------------+



pgsql-novice by date:

Previous
From: David Lloyd
Date:
Subject: Re: [BUGS] Postgres storing time in strange manner
Next
From: Terry Yapt
Date:
Subject: psql and readline library: cursor keys