Even more strange to me is this one below:
pulver=# select date_part('epoch', timestamp 'epoch' + reltime '98529111
seconds');
date_part
-----------
98701911
(1 row)
>
>
>
> ------------------------------------------------------------------------
>
> Subject: Strange behavior with timestamps
> Date: Thu, 08 Mar 2001 13:19:35 -0700
> From: Marc Wrubleski <mlwruble@sorexsoftware.com>
> To: pgsql-admin@postgresql.org
>
> Hi all,
>
> I am witnessing something strange with my timestamps here and I am
> desperately hoping someone can explain or assist.
>
> If I set a time using unix timestamp, it is recalled as a different time
> a week different!
>
> The following example is for illustration purposes:
>
> pulver=# select version();
> version
> -------------------------------------------------------------
> PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc 2.96
>
> pulver=# update connections set starttime = timestamp 'epoch' + reltime
> '984685319';
> UPDATE 1
> pulver=# select date_part('epoch', starttime) from connections;
> date_part
> -----------
> 985290119
> (1 row)