Re: Strange behavior with timestamps - Mailing list pgsql-admin

From Tom Lane
Subject Re: Strange behavior with timestamps
Date
Msg-id 7088.984437604@sss.pgh.pa.us
Whole thread Raw
In response to Strange behavior with timestamps  (Marc Wrubleski <mlwruble@sorexsoftware.com>)
List pgsql-admin
Marc Wrubleski <mlwruble@sorexsoftware.com> writes:
> pulver=# update connections set starttime = timestamp 'epoch' + reltime
> '984685319';

That calculation does not do what you seem to think it does.  (Hint:
reltime is not simply a number of seconds.)

Try just timestamp(984685319) instead.

            regards, tom lane

pgsql-admin by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Use of the LIMIT clause ?
Next
From: "Peter Schuller"
Date:
Subject: Authentication by password