Hi, consider this stripped-down database:
------------------ CREATE TABLE "horde_alarms" ("id" INTEGER PRIMARY KEY, "alarm_end" datetime); INSERT INTO "horde_alarms" VALUES(1, '2013-08-28 22:00:00'); ------------------ These queries work fine: ------------------ sqlite> SELECT * FROM horde_alarms WHERE alarm_end < '2013-08-28T23:08:48'; 1|2013-08-28 22:00:00 sqlite> SELECT * FROM horde_alarms WHERE alarm_end > '2013-08-28 18:08:48'; 1|2013-08-28 22:00:00 ------------------ This query does not work (as used by Horde): ------------------ SELECT * FROM horde_alarms WHERE alarm_end > '2013-08-28T18:08:48'; ------------------ Looks like the handling of ISO-8601 date strings has a problem here. Tested on sqlite 3.7.17. Version 3.6.x is also affected. Best regards, Thomas _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users