shifts Posted September 23, 2012 Share Posted September 23, 2012 Hello World ;-) I;ve been looking at extracting messages from my iPhone without any real special software (aka free) So far I've got the messages out, extracted into a CSV file but the same stamp I'm lost on This is the command I'm running select message.rowid, date, handle.id, message.text from message, handle where message.handle_id=handle.rowid[/CODE] In the DB table date is stored as an integer. So is there a way to run the query but output the date as a proper time and date format? Thanking you in advance. Link to comment Share on other sites More sharing options...
0 AnthonySterling Posted September 23, 2012 Share Posted September 23, 2012 What type of database is it? It sounds like the integer could be a UNIX timestamp, check the documentation for guidance on how to convert this. Link to comment Share on other sites More sharing options...
0 shifts Posted September 23, 2012 Author Share Posted September 23, 2012 It's an SQL Lite db. Basically it's the DB format of what the iPhone uses to store texts, imessages in etc. I'll see if I can find a link to it's schematics. My DB skills only go as far as that query above which i cobbled together from my memories of SQL in college some 16 years ago :D Link to comment Share on other sites More sharing options...
0 simplezz Posted September 23, 2012 Share Posted September 23, 2012 I store dates in julian format in my sqlite databases, so it's probably something similar. There are usually conversion functions in various programming languages. Sqlite has some built-in date/time functions . Maybe they'll do what you need. Link to comment Share on other sites More sharing options...
Question
shifts
Hello World ;-)
I;ve been looking at extracting messages from my iPhone without any real special software (aka free)
So far I've got the messages out, extracted into a CSV file but the same stamp I'm lost on
This is the command I'm running
In the DB table date is stored as an integer.
So is there a way to run the query but output the date as a proper time and date format?
Thanking you in advance.
Link to comment
Share on other sites
3 answers to this question
Recommended Posts