Re: 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 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
> pgman(at)candle(dot)pha(dot)pa(dot)us | (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 majordomo(at)postgresql(dot)org)
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073