Home > mailing lists

internal format of timstamp? - Mailing list pgsql-sql

From	Lars Gustafsson
Subject	internal format of timstamp?
Date	December 29, 2011 14:08:19
Msg-id	193A440A-E7E7-4772-9C28-684E7FD29511@mac.com Whole thread Raw
Responses	Re: internal format of timstamp?
List	pgsql-sql

Tree view

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.

pgsql-sql by date:

From: Filip Rembiałkowski
Date: 27 December 2011, 12:27:18
Subject: Re: Call a external app on postgreSQL start-up (windows)

From: Jasen Betts
Date: 29 December 2011, 20:01:56
Subject: Re: internal format of timstamp?

internal format of timstamp? - Mailing list pgsql-sql

Previous

Next