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. -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users