Skip site navigation (1) Skip section navigation (2)

Re: [NOVICE] Postgres storing time in strange manner

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 (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-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)

In response to

Responses

pgsql-novice by date

Next:From: Ron JohnsonDate: 2002-09-16 10:16:48
Subject: Re: [BUGS] Postgres storing time in strange manner
Previous:From: Casey Allen ShobeDate: 2002-09-15 18:27:03
Subject: Re: Postgres storing time in strange manner

pgsql-bugs by date

Next:From: Neil ConwayDate: 2002-09-16 03:17:36
Subject: Re: Bug #758: show_planner_stats does not work for new PREPARE calls
Previous:From: ChrisDate: 2002-09-15 21:37:58
Subject: Re: Web page

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group