Re: [sqlite] Simple data conversion in SQLite - please help

2014-01-24 Thread Klaas V
On Jan 22, 2014, at 8:21 AM, Richard Hipp wrote: > I seem to recall seeing some SMS databases off of an iPhone that used unix > timestamps for the date/time. That would be seconds since 1970. You can > use the 'unixepoch' modifier on the date functions within SQLite to do >

Re: [sqlite] Simple data conversion in SQLite - please help

2014-01-22 Thread Ward Willats
On Jan 22, 2014, at 8:21 AM, Richard Hipp wrote: > I seem to recall seeing some SMS databases off of an iPhone that used unix > timestamps for the date/time. That would be seconds since 1970. You can > use the 'unixepoch' modifier on the date functions within SQLite to do >

Re: [sqlite] Simple data conversion in SQLite - please help

2014-01-22 Thread Richard Hipp
On Wed, Jan 22, 2014 at 10:46 AM, Kees Nuyt wrote: > On Wed, 22 Jan 2014 12:42:27 -, "DJ Small Paul" < > i...@djsmallpaul.co.uk> wrote: > > >Hi everyone, > > > > > > > >I hope this is an easy one for you! > > > > > > > >I've got an SQLite 3 database from an iphone app. I've

Re: [sqlite] Simple data conversion in SQLite - please help

2014-01-22 Thread Kees Nuyt
On Wed, 22 Jan 2014 12:42:27 -, "DJ Small Paul" wrote: >Hi everyone, > > > >I hope this is an easy one for you! > > > >I've got an SQLite 3 database from an iphone app. I've pulled a table out >and the "date" column is in double binary - How do I see it as the

[sqlite] Simple data conversion in SQLite - please help

2014-01-22 Thread DJ Small Paul
Hi everyone, I hope this is an easy one for you! I've got an SQLite 3 database from an iphone app. I've pulled a table out and the "date" column is in double binary - How do I see it as the actual "date"?? Thank in advance for your help, Paul