| From: | David Lloyd <lloy0076(at)rebel(dot)net(dot)au> |
|---|---|
| To: | Casey Allen Shobe <cshobe(at)secureworks(dot)net> |
| Cc: | Rod Taylor <rbt(at)rbt(dot)ca>, pgsql-bugs(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: [NOVICE] Postgres storing time in strange manner |
| Date: | 2002-09-15 22:15:09 |
| Message-ID: | 3D85066D.90320206@rebel.net.au |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-novice |
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...
DSL
--
Con te partiro, su navi per mari
Che io lo so, no, no non esistono piu
Con te io li vivro.
(Sartori F, Quarantotto E)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Neil Conway | 2002-09-16 03:17:36 | Re: Bug #758: show_planner_stats does not work for new PREPARE calls |
| Previous Message | Chris | 2002-09-15 21:37:58 | Re: Web page |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Johnson | 2002-09-16 10:16:48 | Re: [BUGS] Postgres storing time in strange manner |
| Previous Message | Casey Allen Shobe | 2002-09-15 18:27:03 | Re: Postgres storing time in strange manner |