Converting date from rawdata

Currently reading:
Converting date from rawdata

ak916

New member
Joined
Jan 15, 2015
Messages
2
Points
1
I have accessed the rawdata using SQlite browser. From there i exported it to a CSV file and i have all the data that i need. The only problem is that the date is in a different format. For ex:

Start date : 1420122960000

The above, somehow translated to 1st Jan 2015 2:36 pm.

I need some help on this.

For someone who needs to know where the file was located, it is in the C:\Users\username\AppData\Roaming\com.fiat.convergence.385E4263E7379A5D22A7076E99B02868EFF10711.1\Local Store.

The file name is ecoDriveJourney-v2.0.db.

I downloaded SQL lite browser to view this file.
 
Well, here is the solution. A friend found a site for me which converts those dates. You need to look for an Epoch Converter. I guess I shouldnt be posting any website urls on the forum, so i wont. There is a formula to do this in excel too. Google it. But that website does all that and exports the output file to a .csv format, from which you can copy paste back to your original spreadsheet!
 
Back
Top