internal format of timstamp?

From: Lars Gustafsson <gumse(at)mac(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: internal format of timstamp?
Date: 2011-12-29 15:08:01
Message-ID: 193A440A-E7E7-4772-9C28-684E7FD29511@mac.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

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

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

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

Regards,
Lars.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jasen Betts 2011-12-29 20:42:49 Re: internal format of timstamp?
Previous Message Filip Rembiałkowski 2011-12-27 13:26:38 Re: Call a external app on postgreSQL start-up (windows)