SQL Query Works But Date is exporting as an integer..

[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

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.

[AnthonySterling]

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.

[shifts]

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

[simplezz]

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.