On 18 Mar 2018, at 21:48, Jonathan Moules <jonathan-li...@lightpear.com> wrote:
> CREATE TABLE lookups ( > url_id INTEGER REFERENCES urls (url_id), > retrieval_datetime DATETIME, > error_code INTEGER, > is_generic_flag BOOLEAN -- about one in 100 will have this > flagged > ); SQLite has no DATETIME or BOOLEAN datatype, see: <http://www.sqlite.org/datatype3.html> Given this, I don't know what your attempts to compare date/times will do. Personally I store all date/times as seconds since the epoch; it simplifies life a lot. -- Cheers -- Tim _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
