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@candle.pha.pa.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@postgresql.org)
> 

--  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