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 Momjian wrote: > 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 > hours, 0 minutes, 0 seconds, January 1, 1970, Coordinated Universal Time. > > Also, why does my TimeZone show as Poland? > > test=> SHOW TimeZone; > TimeZone > ---------- > Poland > (1 row) > > -- > Bruce Momjian | http://candle.pha.pa.us > [EMAIL PROTECTED] | (610) 359-1001 > + If your life is a hard drive, | 13 Roberts Road > + Christ can be your backup. | Newtown Square, Pennsylvania 19073 > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly