Re: [ADMIN] Strange behavior with timestamps

[Tom Lane]

Marc Wrubleski <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl