Re: internal format of timstamp?

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: internal format of timstamp?
Date: 2011-12-29 20:42:49
Message-ID: jdijc9$see$2@reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 2011-12-29, Lars Gustafsson <gumse(at)mac(dot)com> wrote:
> 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 ?

possibly that's a floating point timestamp try it as float8 instead of
int8.

--
⚂⚃ 100% natural

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Brent Dombrowski 2011-12-29 21:42:59 Re: internal format of timstamp?
Previous Message Lars Gustafsson 2011-12-29 15:08:01 internal format of timstamp?