timestamp cast to abstime problem - Mailing list pgsql-hackers

From Bruce Momjian
Subject timestamp cast to abstime problem
Date
Msg-id 200210210146.g9L1kD509432@candle.pha.pa.us
Whole thread Raw
Responses Re: timestamp cast to abstime problem  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
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
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pg_dump and large files - is this a problem?
Next
From: Philip Warner
Date:
Subject: Re: pg_dump and large files - is this a problem?