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 end' This query should return nothing, so can anyone explain why it is recording the tsid thanks _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users