Hello, I run into an Epoch Time value that contains five decimal digits besides it's standard integer number.
I already know how to convert integer epoch values, but I'm having a hard time getting a precise conversion of epoch time with decimal digits.
Here's an example Epoch Time value I found in Consolidated.db inside the CellLocation Table, TimeStamp field :
311660150.444390
I know that 311660150 is equal to 2010/11/18 @ 04:15:49
(I would assume it's the GMT as usual).
By comparing with previous entries and measuring the GPS location differences of each record on the table, I'm positively sure the above converted time is not accurate.
Now, how do I add the decimal portion ( 0.444390 ) to get the precise time?
Thanks in advance.
I already know how to convert integer epoch values, but I'm having a hard time getting a precise conversion of epoch time with decimal digits.
Here's an example Epoch Time value I found in Consolidated.db inside the CellLocation Table, TimeStamp field :
311660150.444390
I know that 311660150 is equal to 2010/11/18 @ 04:15:49
(I would assume it's the GMT as usual).
By comparing with previous entries and measuring the GPS location differences of each record on the table, I'm positively sure the above converted time is not accurate.
Now, how do I add the decimal portion ( 0.444390 ) to get the precise time?
Thanks in advance.