It depends on the purpose for which you are using SQLite. It sure makes it ugly trying to convert an existing application TO SQLite. Oracle-like TO_DATE and TO_CHAR functions would be a big help.
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Igor Tandetnik Sent: Wednesday, January 21, 2009 10:57 AM To: [email protected] Subject: Re: [sqlite] Date datatype 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 _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
