Re: [GENERAL] binary timestamp conversion

2009-08-17 Thread Sam Mason
On Mon, Aug 17, 2009 at 11:35:41AM +0200, David De Maeyer wrote: > Being on a FreeBSD box, and having PostgreSQL compiled with default > options, I am assuming timestamps are encoded as long long (a signed > long for the date and an unsigned long for the time). Integer timestamps are the number of

Re: [GENERAL] binary timestamp conversion

2009-08-17 Thread Alvaro Herrera
David De Maeyer wrote: > I am now facing a puzzling challenge: converting binary timestamp > data! If pgfsck did properly recover the timestamp data as a binary > string, pgfsck will use a default timestamp, "1900-01-01 00:00:00", > presumably because the date/time encoding varies from platform to