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

Re: Postgres storing time in strange manner

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: Casey Allen Shobe <cshobe(at)secureworks(dot)net>
Cc: 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:11:04
Message-ID: 1032099066.19130.4.camel@jester (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-novice
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.

-- 
  Rod Taylor


In response to

Responses

pgsql-novice by date

Next:From: Casey Allen ShobeDate: 2002-09-15 14:16:23
Subject: Re: Postgres storing time in strange manner
Previous:From: Casey Allen ShobeDate: 2002-09-15 12:32:57
Subject: RESOLVED: Deep quotation

pgsql-bugs by date

Next:From: botik32Date: 2002-09-15 14:11:14
Subject: Memory leak in client application
Previous:From: Casey Allen ShobeDate: 2002-09-15 12:17:18
Subject: Referencing a superselect's column by it's declared alias from a subselect fails

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