Re: [GENERAL] binary timestamp conversion - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: [GENERAL] binary timestamp conversion
Date
Msg-id 7448.1129323875@sss.pgh.pa.us
Whole thread Raw
In response to Re: [GENERAL] binary timestamp conversion  (H Hale <hhale21@yahoo.com>)
Responses Re: [GENERAL] binary timestamp conversion
List pgsql-interfaces
H Hale <hhale21@yahoo.com> writes:
> I save 1970-01-01 00:00:00 and read it back expecting
> the difference between postgres and unix epochs but
> get different results each time. 

> (After conversion to host byte order).

Sounds to me like you're picking up garbage rather than the data you
should.  Does your code to fetch the binary value produce correct
answers on an ordinary int8 column?
        regards, tom lane


pgsql-interfaces by date:

Previous
From: H Hale
Date:
Subject: Re: [GENERAL] binary timestamp conversion
Next
From: Michael Fuhr
Date:
Subject: Re: [GENERAL] binary timestamp conversion