On 10 Aug 2014, at 1:51am, Philip Bennefall <phi...@blastbay.com> wrote:
> That is what I tried to do in my query examples that I included in the > original message. Based on those, would you say that I am doing it correctly? I didn't figure out what you actually have stored in the database. If you have text stored, and are trying to find things stored that aren't real dates, you should be able to do something like this: SELECT * FROM Orders WHERE date(julianday(orderDate)) != orderDate If you're still at the planning stage, or can revise your table, it's usually considered better to store numbers than dates. This makes comparisons and maths faster. In your case I'd probably store a Julian Date since you only care about date and not time. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
