Zitat von Igor Tandetnik <i...@tandetnik.org>:

SQLite doesn't have "datetime" data type. All these values are plain strings, and are compared as such. It just so happens that, if you use a suitable format consistently, usual string comparisons also order dates and times correctly.

So, don't mix and match the format with and without T in the middle. Choose one, and stick to it.

thanks for the quick explanation. Now that's what I would call a funny issue :)

I'll prepare an upstream horde fix.

Best regards,
Thomas

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to