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
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.