Re: [BUGS] Postgres storing time in strange manner

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: [BUGS] Postgres storing time in strange manner
Дата
Msg-id 1032171408.24696.18.camel@haggis
обсуждение исходный текст
Ответ на Re: [BUGS] Postgres storing time in strange manner  (David Lloyd <lloy0076@rebel.net.au>)
Список 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 по дате отправления:

Предыдущее
От: David Lloyd
Дата:
Сообщение: Re: [BUGS] Postgres storing time in strange manner
Следующее
От: Terry Yapt
Дата:
Сообщение: psql and readline library: cursor keys