Greg Robertson <[EMAIL PROTECTED]> wrote: > I would like to do a date search to find records that are between two > dates. The dates are stored in the table in the format DD-MM-YYYY but > I can change that to another format but I prefer something readable > rather than an int or double.
Just do YYYY-MM-DD. Then a simple string comparison also happens to be correct for dates. For more complex date and time manipulation, see http://sqlite.org/lang_datefunc.html Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
