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