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

Re: BUG #1117: Time calculation from epoch is 12 hours out

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Neil Cooper <neil(dot)cooper(at)scigames(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1117: Time calculation from epoch is 12 hours out
Date: 2004-03-27 03:55:46
Message-ID: 20040326195104.M83786@megazone.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On Fri, 26 Mar 2004, PostgreSQL Bugs List wrote:

> The following bug has been logged online:
>
> Bug reference:      1117
> Logged by:          Neil Cooper
>
> Email address:      neil(dot)cooper(at)scigames(dot)com
>
> PostgreSQL version: 7.3.4
>
> Operating system:   Red Hat ES 3.0
>
> Description:        Time calculation from epoch is 12 hours out
>
> Details:
>
> I'm using the PostgreSQL that comes with Red Hat ES 3.0. (psql reports
> 7.3.4-R.H). For purposes of testing/reporting, my workstation is running on
> UTC time to avoid any potential timezone confusions.
>
> OK heres the problem:
>
> The output of the following query:
> select '1970-1-1 00:00:00'::timestamp + '1080302400 seconds'::reltime;

It seems to be a problem with reltime.  I'd suggest just avoiding reltime
entirely and using interval instead.

In response to

pgsql-bugs by date

Next:From: Bruno Wolff IIIDate: 2004-03-27 06:12:38
Subject: Re: Bug#225680: Fwd: Default pg_autovacuum config glitches
Previous:From: Tom LaneDate: 2004-03-27 03:42:51
Subject: Re: BUG #1117: Time calculation from epoch is 12 hours out

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