Jump to content

4 posts in this topic

Posted

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

[CODE]
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.

Share this post


Link to post
Share on other sites

Posted

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.

Share this post


Link to post
Share on other sites

Posted

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

Share this post


Link to post
Share on other sites

Posted

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 [url="http://www.sqlite.org/lang_datefunc.html"]functions [/url]. Maybe they'll do what you need.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.