Re: [sqlite] Date Search

2018-07-05 Thread R Smith
On 2018/07/05 8:51 PM, dmp wrote: Given: SELECT STRFTIME('%s', '2018-01-01'); 1514764800 SELECT STRFTIME('%s', '2017-01-01'); 1483228800 CREATE TABLE date_types( id INTEGER PRIMARY KEY, date_type DATE ); INSERT INTO "date_types" ("id", "date_type") VALUES(1, 1514764800); INSERT INTO

Re: [sqlite] Date Search

2018-07-05 Thread David Raymond
8-%-%'; QUERY PLAN `--SCAN TABLE date_types -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of dmp Sent: Thursday, July 05, 2018 2:51 PM To: sqlite-users@mailinglists.sqlite.org Subject: [sqlite] Date Search Given: SELECT STRFTIM

Re: [sqlite] Date Search

2018-07-05 Thread Keith Medcalf
ists.sqlite.org] On Behalf Of dmp >Sent: Thursday, 5 July, 2018 12:51 >To: sqlite-users@mailinglists.sqlite.org >Subject: [sqlite] Date Search > >Given: > >SELECT STRFTIME('%s', '2018-01-01'); >1514764800 >SELECT STRFTIME('%s', '2017-01-01'); >1483228800 > >CREATE T

[sqlite] Date Search

2018-07-05 Thread dmp
Given: SELECT STRFTIME('%s', '2018-01-01'); 1514764800 SELECT STRFTIME('%s', '2017-01-01'); 1483228800 CREATE TABLE date_types( id INTEGER PRIMARY KEY, date_type DATE ); INSERT INTO "date_types" ("id", "date_type") VALUES(1, 1514764800); INSERT INTO "date_types" ("id", "date_type")