Hoover, Jeffrey <[email protected]> wrote: > You are comparing the values as strings. > > Instead, format your dates as YYYY-MM-DD and use the date function to > convert strings to dates for comparison:
If you use YYYY-MM-DD format consistently, then simple string comparison just happens to give the same results as date comparison. Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
