On Dec 29, 2011, at 7:08 AM, 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…..
> 
> 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.
> -- 
> 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#DATATYPE-DATETIME-INTERNALS

Brent.


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Reply via email to