Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

From this site, I learned about the "secret" file that stores my gps info.

I tried to open the file, and I got this SQLite DB.

How can I interpret the timestamp info?

enter image description here

share|improve this question… – Moab Apr 21 '11 at 22:29 – Moab Apr 21 '11 at 23:34

iOS (and Mac OS X) use the NSDate epoch, which means that time is recorded as the number of seconds since the first instant of 1-Jan-2001 UTC. The more common Unix epoch is based on 1970 instead. The difference between the two is 978307200 seconds. To convert, add that amount to the values you see.

The Unix Epoch Converter mentioned by Shark lists different ways of converting the epoch-seconds to a human-readable date at the bottom of the page. For example, using JavaScript, you convert the seconds to milliseconds and create a Date object. You can see this in a browser by typing the following in the location field:

javascript:alert(new Date((978307200+323827707.004303)*1000).toLocaleString())

which converts the Date to the local time zone and format, and displays it with an alert dialog box.

share|improve this answer

run the following query

SELECT datetime(323827707, 'unixepoch', 'localtime');

Also you could head to epochconverter to search manually

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.