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

From David Lloyd
Subject Re: [BUGS] Postgres storing time in strange manner
Date
Msg-id 3D85066D.90320206@rebel.net.au
Whole thread Raw
In response to Postgres storing time in strange manner  (Casey Allen Shobe <cshobe@secureworks.net>)
Responses Re: [BUGS] Postgres storing time in strange manner  (Ron Johnson <ron.l.johnson@cox.net>)
List 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)

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: [BUGS] Postgres storing time in strange manner
Next
From: Ron Johnson
Date:
Subject: Re: [BUGS] Postgres storing time in strange manner