On 08 Mar 2017 at 20:40, Paul Sanderson <sandersonforens...@gmail.com> wrote:
> The vast majority of dates I see in SQLite databases are unix epoch integer > times (seconds since 1/1/1980) with unix milli seconds a close second. > Efficient to store, sort and do date arithmetic on but need to be converted > to display. This is also what I do; seconds since the epoch. I can't imagine string dates or times as strings. You're also going to need to give the user the option to select their date/time format, too, so converting to display should be done at display time, not before. -- Cheers -- Tim _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
