JokBoy wrote: > I have tried your query and I don't get any rows returned. Any ideas > why it wouldn't work?
If you tried it against the database file you showed in your original post, note that you have MOEData.Date in different format from Criteria.StartTime_crit and EndTime_crit. Recall that SQLite doesn't have a dedicated date/time type: those fields are just strings, and are compared as strings, lexicographically. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users