Re: [sqlite] Subject: Re: Date Search

2018-07-06 Thread Keith Medcalf
@mailinglists.sqlite.org] On Behalf Of dmp >Sent: Friday, 6 July, 2018 10:52 >To: sqlite-users@mailinglists.sqlite.org >Subject: [sqlite] Subject: Re: Date Search > >Keith wrote: >> Correct. >> You have stored integer Unix Epoch timestamps. You cannot do >"strin

[sqlite] Subject: Re: Date Search

2018-07-06 Thread dmp
Keith wrote: > Correct. > You have stored integer Unix Epoch timestamps. You cannot do "string" > searches on integers (at least not ones like what you have asked for, > which involves conversion of an integer representing a Unix Epoch offset > to an ISO-8601 string, not to an ordinary "string