Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125])
	by mail.postgresql.org (Postfix) with ESMTP id 213E66B258B
	for <pgsql-sql@postgresql.org>; Thu, 29 Dec 2011 11:08:17 -0400 (AST)
Received: from smtprelay-b21.telenor.se ([195.54.99.212])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <gumse@mac.com>) id 1RgHab-0004eR-4j
	for pgsql-sql@postgresql.org; Thu, 29 Dec 2011 15:08:17 +0000
Received: from ipb3.telenor.se (ipb3.telenor.se [195.54.127.166])
	by smtprelay-b21.telenor.se (Postfix) with ESMTP id EA275DF03
	for <pgsql-sql@postgresql.org>; Thu, 29 Dec 2011 16:08:03 +0100 (CET)
X-SENDER-IP: [83.227.158.2]
X-LISTENER: [smtp.bredband.net]
X-IronPort-Anti-Spam-Filtered: true
X-IronPort-Anti-Spam-Result: 
 AssbAL+B/E5T454CPGdsb2JhbAAMN4lWoDOCewEBAQE3hDIWvgOIdYI3YwSnNw
X-IronPort-AV: E=Sophos;i="4.71,427,1320620400"; d="scan'208";a="23827834"
Received: from ua-83-227-158-2.cust.bredbandsbolaget.se (HELO
	[192.168.44.200]) ([83.227.158.2])
	by ipb3.telenor.se with ESMTP; 29 Dec 2011 16:08:01 +0100
From: Lars Gustafsson <gumse@mac.com>
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable
Subject: internal format of timstamp?
Date: Thu, 29 Dec 2011 16:08:01 +0100
Message-Id: <193A440A-E7E7-4772-9C28-684E7FD29511@mac.com>
To: pgsql-sql@postgresql.org
Mime-Version: 1.0 (Apple Message framework v1251.1)
X-Mailer: Apple Mail (2.1251.1)
X-Pg-Spam-Score: -1.2 (-)
X-Archive-Number: 201112/84
X-Sequence-Number: 36145

Hi,

I am trying to recover a lot of deleted rows from a database  ( pg 8.2.3 =
) , not my database, I promise=85..

When using the tool pgfsck I get good results, but timestamp is not =
implemented.

When trying to export as int8  i get   fx.  4735129360236469258   =
representing   december 29, 2011, 16:30 =20

But how should I do the conversion from the numeric value to the actual =
timestamp ?

Regards,
Lars.=