Re: [HACKERS] timestamp cast to abstime problem

I figured this all out; turns out they were related. I had set my timezone in the postmaster to Poland long ago and forgot, and that is why both the abstime and show timezone produced strange results. Sorry. --- Bruce Mom

[HACKERS] timestamp cast to abstime problem

Does anyone know why this returns 0 and not 3600? test=> select '1970-01-01 01:00:00'::timestamp::abstime::int4; int4 -- 0 (1 row) My time(2) manual page says: The time() function returns the value of time in seconds since 0 hou