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.
That's the normal epoch point zero. There are systems starting on January 1, 1904 Perhaps other dates are used as well. Klaas `Z4us` V _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
