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

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.