Re: Some timestamp problems - Mailing list pgsql-admin

From Bruno Wolff III
Subject Re: Some timestamp problems
Date
Msg-id 20020829225527.GA347@wolff.to
Whole thread Raw
In response to Re: Some timestamp problems  ("Vilson farias" <vilson.farias@digitro.com.br>)
List pgsql-admin
On Thu, Aug 29, 2002 at 17:59:15 -0300,
  Vilson farias <vilson.farias@digitro.com.br> wrote:
> But there are two kind of problems there. First related with big date
> values. ok, bot big deal yet :), but the second is taking my attention : if
> you put a time with 995 to 999 miliseconds, it's represented as 60seconds
> instead of 59seconds and 995 to 999 miliseconds. I don't think it's alright,
> because I've never seen a datetime with 60seconds value (60 seconds is
> always the next minute, in my conception). I would like some light here, is
> it just a psql problem to show datetime values or a internal datetime
> storage problem?

Note that if you are using UTC there are leap seconds stuck in or removed
from time to time. So you can have a 61st (and I think even a 62nd) second
in a given minute.

pgsql-admin by date:

Previous
From: Murthy Kambhampaty
Date:
Subject: Re: Interpretting WAL debug.
Next
From: David Wheeler
Date:
Subject: Re: Silencing NOTICEs in Perl Pg