Quoth YAN HONG YE <yanhong...@mpsa.com>, on 2012-11-09 08:28:53 +0000: > The result let crazy.
Because they're STRINGS! There is NO DATE TYPE in SQLite! Not to mention if those values are intended to be ISO 8601, they should have zero padding; it should be "2012-09-07" and such---in which case they will compare correctly because that's the way that date format was designed, but it won't happen just because. The string "29" comes before the string "3" because "2" comes before "3". It doesn't automatically figure out what a string is "supposed" to be and compare accordingly. ---> Drake Wilson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users