On Jul 2, 9:52 am, David Fisher <[email protected]> wrote: > In my experience, Sqlite3 doesn't handle most strings well for date > comparisons. It works sometimes, but not always. Postgres has treated > me much better so far in this regard.
Yes. As I mentioned, on SQLite, it requires the strings match exactly. If you always provided the dates as Date objects, the same format should be used. If you ever used strings with a different format than Sequel's default, you can't use dates. There are a few options: 1) Use a better database (such as PostgreSQL) 2) Convert all dates in the database to the standard ISO format that Sequel uses, and always use Date objects instead of Strings when dealing with date columns. 3) Use the date/time functions in SQLite to convert all dates to a common format (http://sqlite.org/lang_datefunc.html) 4) Store the year, month, and day in separate columns Jeremy --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en -~----------~----~----~----~------~----~------~--~---
