Posted: 12/15/2013 5:25:58 PM EDT
|
So my galaxy S3 was running slow and I decided to load a new rom (hyperdrive). Took a backup in recovery just in case something went wrong or I didn't like it. I got everything set up, then I realized I never backed up the logs that I use to track my fuel mileage/fillups. I use a program called GasLog. No big deal I figured, I could just load my backup, export the data, go to new rom, import it and be good to go. Well apparently my backup wasn't complete for some reason. FUCK! There is over a year of data! I know, my fault, but now Im trying to get it back. I managed to dig up a .db file from the folder and when I open it in an SQLite reader, I can see all my entries. It has my odometer, cost, date, etc. Basically ALL the data I need, but it won't import correctly as a backup. I can retype the data but the issue I have, and where I need help is the date string. I expected a format I could understand (MMDDYYYY, MMDDYYYYHHMMSS, etc), but this looks almost like a random number. Its a 13 character string. Is there anyone who may be able to help?
Here are a couple examples; I know the corresponding date to the string for a couple recent ones, but I can't make any sense of it. 1385583240000 corresponds to a fillup I did on 11/27/13 1386245340000 corresponds to a fillup I did on 12/5/13  
|
|
Quoted:
FUCK YES!!!!!!! thats it!!! Thank you!!!!   
ARFCOM FTW! Quoted:
Quoted:
Its probably stored in milliseconds since epoch. Jan 1 1970. FUCK YES!!!!!!! thats it!!! Thank you!!!!
ARFCOM FTW! yep, UNIX timestamp. http://en.wikipedia.org/wiki/Unix_time |