On 17 Mar 2010, at 10:49am, Mike Martin wrote:

> 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 end'
> 
> This query should return nothing, so can anyone explain why it is
> recording the tsid

Your sample start time has a hyphen between date and time.  Is this mistyping 
when you wrote your email or is it in your data file like that ?

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to