Strange behavior with timestamps cont.
От | Marc Wrubleski |
---|---|
Тема | Strange behavior with timestamps cont. |
Дата | |
Msg-id | 3AA7F254.153CCEF9@sorexsoftware.com обсуждение исходный текст |
Список | 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@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)
В списке pgsql-admin по дате отправления: