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
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
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
3 matches
Mail list logo