Register Login
The UK's No.1 Chrysler Owners Forum
Reply
 
Thread Tools Search this Thread
Old 15-01-2015   #1
Join Date: Jan 2015
Posts: 2
Thanks: 0
Trader Rating: 0
India 
Converting date from rawdata

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.converg ence.385E4263E7379A5D22A7076E99B02868EFF10711.1\Lo cal Store.

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

I downloaded SQL lite browser to view this file.
__________________
FIAT Forum Useful Links:
Donate to FF | Buy FF Merchandise | Classifieds | FF Insurance | How-to Guides

ak916 is offline Reply With Quote Quote 
Old 15-01-2015   #2
Join Date: Jan 2015
Posts: 2
Thanks: 0
Trader Rating: 0
India 
Re: Converting date from rawdata

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!
__________________
FIAT Forum Useful Links:
Donate to FF | Buy FF Merchandise | Classifieds | FF Insurance | How-to Guides

ak916 is offline Reply With Quote Quote 
Reply
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump
Similar Threads
Thread Thread Starter Forum Replies Last Post
converting to rwd ren the bear Lets Talk FIAT 21 11-02-2019 15:48
(G) converting to LPG terri4 Ulysse 6 04-12-2011 19:28
Converting Files bludvl_x19 Computing 4 16-04-2007 02:38
converting mp3's patrick FIAT Boo Archives 7 21-01-2006 11:18