| From: | Brent Dombrowski <brent(dot)dombrowski(at)gmail(dot)com> |
|---|---|
| To: | Lars Gustafsson <gumse(at)mac(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: internal format of timstamp? |
| Date: | 2011-12-29 21:42:59 |
| Message-ID: | 4DA72F25-6139-41B4-AE30-93072A7B337C@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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(at)postgresql(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Crawford | 2011-12-29 22:20:28 | Re: internal format of timstamp? |
| Previous Message | Jasen Betts | 2011-12-29 20:42:49 | Re: internal format of timstamp? |