On 12 Aug 2019, at 00:43, Keith Medcalf <kmedc...@dessus.com> wrote: > On Sunday, 11 August, 2019 16:02, Richard Damon <rich...@damon-family.org> > wrote: > >>On 8/11/19 4:21 PM, Thomas Kurz wrote: > >>>> I do understand the value of having date/time types in SQLite, but >>>> it is not easy to do while retaining backward compatibility. > > I do not see any value in having a date/time type is SQLite.
Neither do I. The correct way is to store, as an integer, seconds (or whatever time unit you want) since some epoch. The display of what that stored value means is a *presentation* issue and should be handled as such by whatever language is presenting to the user. That also allows the program to either allow the user to presentation format to suit themselves, or for the program to follow the way system prefs are set. -- Cheers -- Tim _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
