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

Sun, 20 Oct 2002 21:46:13 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
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, Pennsylvania 19073

Sun, 20 Oct 2002 22:01:04 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: timestamp cast to abstime problem