On Thu, 8 Oct 2009, Igor Tandetnik wrote: > Actually, columns with these declared types will have NUMERIC affinity.
Thanks, Igor. I missed that. > Realize that YYYY-MM-DD format works not because SQLite treats it somehow > specially, but because for strings in this format, alphabetical order just > happens to match calendar order or dates. But yes, if you store your dates > as YYYY-MM-DD strings, most comparisons will just work. I converted those date formats in a spreadsheet. As soon as I finish cleaning the exported .csv for SQLite I'll be able to delete those rows. Thanks, Rich _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
