> Are there any plans to implement a DATETIME and/or TIMESTAMP field types?
I don't think so. The SQLite team really cares about backward compatibility. You can store timestamp as a unixepoch integer or as a text in format supported by date/time functions. http://www.sqlite.org/draft/lang_datefunc.html 2018-06-02 21:55 GMT+02:00, Thomas Kurz <sqlite.2...@t-net.ruhr>: > Are there any plans to implement a DATETIME and/or TIMESTAMP field types? > > ----- Original Message ----- > From: Simon Slavin <slav...@bigfraud.org> > To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> > Sent: Saturday, June 2, 2018, 21:04:10 > Subject: [sqlite] Subject: Re: SQL Date Import > > On 2 Jun 2018, at 7:32pm, dmp <da...@dandymadeproductions.com> wrote: > >> By the way, most databases give exactly that INSERT when dumping data >> for DATE, TIME, TIMESTAMP, etc., text. I'm not advocating a preferred >> type for storage here. > > I think your proposed programme of experimentation is the right way to > pursue this. But I wanted to save you some time. > > SQLite doesn't have a DATE type. You can store dates in a SQLite database > as text, or integers or floating point numbers (e.g. "20180602", a number of > days, a number of seconds). But when you ask for a value, that's what > you'll get back. Any interpretation of that value as a date is up to you or > your software. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
