On 24 Aug 2011, at 6:59pm, GB wrote: > SELECT itemID FROM t WHERE itemID BETWEEN 1000000 AND 2000000 AND > createdAt BETWEEN '2011-08-01' AND '2011-08-02'
Just out of curiosity, try changing both the BETWEEN formulations so it says SELECT itemID FROM t WHERE itemID >= 1000000 AND itemID <= 2000000 AND createdAt >= '2011-08-01' createdAt <= '2011-08-02' Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
