internal format of timstamp?

Поиск
Список
Период
Сортировка
От Lars Gustafsson
Тема internal format of timstamp?
Дата
Msg-id 193A440A-E7E7-4772-9C28-684E7FD29511@mac.com
обсуждение исходный текст
Ответы Re: internal format of timstamp?
Список 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.

В списке pgsql-sql по дате отправления: