Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id B2F806B2593 for ; Thu, 29 Dec 2011 18:20:45 -0400 (AST) Received: from cerberus.pinpointresearch.com ([66.7.238.130] helo=polaris.pinpointresearch.com) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1RgOL4-0004qF-Gn for pgsql-sql@postgresql.org; Thu, 29 Dec 2011 22:20:45 +0000 Received: from betelgeuse.pinpointresearch.com (betelgeuse.pinpointresearch.com [192.168.1.179]) by polaris.pinpointresearch.com (Postfix) with ESMTP id 538ADE00EC82; Thu, 29 Dec 2011 14:20:28 -0800 (PST) Message-ID: <4EFCE7AC.8090206@pinpointresearch.com> Date: Thu, 29 Dec 2011 14:20:28 -0800 From: Steve Crawford User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.2.23) Gecko/20110922 Lightning/1.0b2 Thunderbird/3.1.15 MIME-Version: 1.0 To: Jasen Betts CC: pgsql-sql@postgresql.org Subject: Re: internal format of timstamp? References: <193A440A-E7E7-4772-9C28-684E7FD29511@mac.com> In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: -3.2 (---) X-Archive-Number: 201112/87 X-Sequence-Number: 36148 On 12/29/2011 12:42 PM, Jasen Betts wrote: > On 2011-12-29, Lars Gustafsson wrote: >> Hi, >> >> I am trying to recover a lot of deleted rows from a database ( pg >> 8.2.3 ) , not my database, I promise=E2=80=A6.. >>> When using the tool pgfsck I get good results, but timestamp is not i= mplemented. >> When trying to export as int8 i get fx. 4735129360236469258 repr= esenting december 29, 2011, 16:30 >> >> But how should I do the conversion from the numeric value to the actua= l timestamp ? > possibly that's a floating point timestamp try it as float8 instead of > int8. > > > I am not an internals person, but suspect that your first step should be=20 to check pg_config to see if the server from which you are attempting to=20 recover data was compiled with --enable-integer-datetimes. Cheers, Steve