Strange behavior with timestamps cont.

From: Marc Wrubleski <mlwruble(at)sorexsoftware(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Strange behavior with timestamps cont.
Date: 2001-03-08 20:57:56
Message-ID: 3AA7F254.153CCEF9@sorexsoftware.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)sorexsoftware(dot)com>
> To: pgsql-admin(at)postgresql(dot)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)

Browse pgsql-admin by date

  From Date Subject
Next Message Paul Huppe 2001-03-09 12:40:37 Release of 7.1
Previous Message Marc Wrubleski 2001-03-08 20:19:35 Strange behavior with timestamps