Another reason: because PostgreSQL supports it as well (including timezone) ;-)
----- Original Message ----- From: Peter da Silva <res...@gmail.com> To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Sent: Tuesday, August 13, 2019, 23:18:29 Subject: [sqlite] Backward compatibility vs. new features (was: Re: dates, times and R) If the datr/time is stored internally as utc iso8601 text then it will remain compatible with old versions and can implement whatever new behavior is needed on new versions. The bigger question is 'what new behavior'? The only nee behavior seems to be 'let this third party package see it as a date', which it should be able to figure out by looking at the schema. _______________________________________________ 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