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

Re: Postgres storing time in strange manner

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Casey Allen Shobe <cshobe(at)secureworks(dot)net>,pgsql-bugs(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org
Subject: Re: Postgres storing time in strange manner
Date: 2002-09-15 14:51:34
Message-ID: 1032101495.19130.29.camel@jester (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-novice
On Sun, 2002-09-15 at 10:32, Tom Lane wrote:
> > On Sunday 15 September 2002 10:11 am, Rod Taylor wrote:
> >> On Sun, 2002-09-15 at 03:57, Casey Allen Shobe wrote:
> >>> I don't have a clue why it's doing this - has anyone else seen this sort
> >>> of behavior, or know why it might be doing it?  It shows times wrong, for
> >>> instance, it shows 00:04:60 where it should show 00:05:00.  See below:
> >> 
> >> 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.
> 
> True but irrelevant -- PG does not do accounting for leap seconds.

For some reason I thought it did accommodate it when I was still using
7.1.

Ahh well, if the bug is fixed, then it's all good.

-- 
  Rod Taylor


In response to

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2002-09-15 15:07:55
Subject: Re: Deep quotation
Previous:From: Rod TaylorDate: 2002-09-15 14:49:22
Subject: Re: Postgres storing time in strange manner

pgsql-bugs by date

Next:From: pgsql-bugsDate: 2002-09-15 15:12:03
Subject: Bug #768: Wrong special characters handling in Java
Previous:From: Rod TaylorDate: 2002-09-15 14:49:22
Subject: Re: Postgres storing time in strange manner

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