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-16 10:16:48
Message-ID: 1032171408.24696.18.camel@haggis (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-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

pgsql-novice by date

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

pgsql-bugs by date

Next:From: Tom LaneDate: 2002-09-16 13:27:33
Subject: Re: Explicit timestamp conversion very slow
Previous:From: Tom LaneDate: 2002-09-16 04:51:21
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