On Jan 22, 2014, at 8:21 AM, Richard Hipp <d...@sqlite.org> 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&time functions within SQLite to do > the conversion, if you want.
Yeah, that's what we do in our iOS apps. Try "select datetime( field, 'unixepoch' ) from table" _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users