[HACKERS] timestamp cast to abstime problem

[Bruce Momjian]

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