[sqlite] Problem with between clause and dates

Hi I am getting occasional incorrect results using between operator example table structure recordings ID tsid start end sample time= 2010-03-16 23:06:00 sample start= 2010-03-16-22:00:00 sample end= 2010-03-16 23:05:00 select tsid from recordings where '2010-03-16 23:05:00' between start and

Re: [sqlite] Problem with indexes and speed

Thanks for that Is it possible to do an index on a substring of a field eg: subtr(start,10) to get just the day On 17/01/2009, Igor Tandetnik <itandet...@mvps.org> wrote: > "Mike Martin" <redt...@googlemail.com> wrote > in message > news:ecc841d809

[sqlite] Problem with indexes and speed

Hi I have a relatively simple DB with sqlite 3.5.6 The following query runs in around 10 secs with no indexes, however if I index the start field (datetime) it takes around 10 minutes + Select guide.id,channels.Channel,start,start,name,stop,stop,cat0 from guide join channels on pnr=ind left join