Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125])
	by mail.postgresql.org (Postfix) with ESMTP id 3FF816B2591
	for <pgsql-sql@postgresql.org>; Thu, 29 Dec 2011 17:43:18 -0400 (AST)
Received: from mail-iy0-f174.google.com ([209.85.210.174])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <brent.dombrowski@gmail.com>) id 1RgNko-0003k3-PL
	for pgsql-sql@postgresql.org; Thu, 29 Dec 2011 21:43:18 +0000
Received: by iaeh11 with SMTP id h11so24222260iae.19
	for <pgsql-sql@postgresql.org>; Thu, 29 Dec 2011 13:43:02 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=subject:mime-version:content-type:from:in-reply-to:date:cc
	:content-transfer-encoding:message-id:references:to:x-mailer;
	bh=icAxLCVKFHCktVEWIJgGcF2bHMPVG7uZT6TUL5Uentk=;
	b=gK4KV96p1F22xrl+BSYx9VkNGnwqJjQA9qzzI7EuFq9KreEU2ijijLfSusqTTSbbaf
	zu4B+AAAeO2rTfcP4CGPtQRDokadYNyz0wkOZ09XRMj4qkqG1ZxgfAX3xxmt3Cy+d5Qq
	aQRDpSVww2GXHZ2Nmy+XW94C/MBz9ocP9letY=
Received: by 10.50.47.229 with SMTP id g5mr13155160ign.23.1325194982379;
	Thu, 29 Dec 2011 13:43:02 -0800 (PST)
Received: from [10.9.73.20] (173-164-88-9-Oregon.hfc.comcastbusiness.net.
	[173.164.88.9])
	by mx.google.com with ESMTPS id uc6sm1913473igb.4.2011.12.29.13.43.01
	(version=TLSv1/SSLv3 cipher=OTHER);
	Thu, 29 Dec 2011 13:43:01 -0800 (PST)
Subject: Re: internal format of timstamp?
Mime-Version: 1.0 (Apple Message framework v1251.1)
Content-Type: text/plain; charset=windows-1252
From: Brent Dombrowski <brent.dombrowski@gmail.com>
In-Reply-To: <193A440A-E7E7-4772-9C28-684E7FD29511@mac.com>
Date: Thu, 29 Dec 2011 13:42:59 -0800
Cc: pgsql-sql@postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <4DA72F25-6139-41B4-AE30-93072A7B337C@gmail.com>
References: <193A440A-E7E7-4772-9C28-684E7FD29511@mac.com>
To: Lars Gustafsson <gumse@mac.com>
X-Mailer: Apple Mail (2.1251.1)
X-Pg-Spam-Score: -2.6 (--)
X-Archive-Number: 201112/86
X-Sequence-Number: 36147

On Dec 29, 2011, at 7:08 AM, Lars Gustafsson wrote:

> Hi,
>=20
> I am trying to recover a lot of deleted rows from a database  ( pg =
8.2.3 ) , not my database, I promise=85..
>=20
> When using the tool pgfsck I get good results, but timestamp is not =
implemented.
>=20
> When trying to export as int8  i get   fx.  4735129360236469258   =
representing   december 29, 2011, 16:30 =20
>=20
> But how should I do the conversion from the numeric value to the =
actual timestamp ?
>=20
> Regards,
> Lars.
> --=20
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql

I'm not sure what the internal timestamp representation is, but I =
thought it went down to fractions of a second.

=
http://www.postgresql.org/docs/8.2/interactive/datatype-datetime.html#DATA=
TYPE-DATETIME-INTERNALS

Brent.