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,
CoordinatedUniversal Time.
Also, why does my TimeZone show as Poland?test=> SHOW TimeZone; TimeZone ---------- Poland(1 row)
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073