On 2 Jun 2018, at 8:55pm, Thomas Kurz <sqlite.2...@t-net.ruhr> wrote:
> Are there any plans to implement a DATETIME and/or TIMESTAMP field types? No. SQLite has many routines which understand standard ways of storing datestamps: <https://sqlite.org/lang_datefunc.html> So you can store IS0-8601-format strings, unix epoch, or Julian day, and use SQLite routines to do things like "get four weeks before the Monday just previous to this date" and "get the third Wednesday of the month after this date". One problem with having an actual internal date format is how to dump it into a text file or to a text interface. You end up turning it into a number or a string anyway, so you might was well store it that way. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users