On Wed, Jan 22, 2014 at 10:46 AM, Kees Nuyt <k.n...@zonnet.nl> wrote:
> On Wed, 22 Jan 2014 12:42:27 -0000, "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 pulled a table out > >and the "date" column is in double binary - How do I see it as the actual > >"date"?? > > It is probably in Julianday format: > > http://sqlite.org/lang_datefunc.html > > perhaps with an Apple specific offset. > Aplle sometimes uses its own perception of day zero, > however, I forgot what date that was. > Some simple experiments will tell you. > > I hope this helps. > > 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&time functions within SQLite to do the conversion, if you want. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users