Tickets :: Comment on [#11886] Event notifications do not work for the current day

* Your Email Address
* Spam protection	Enter the letters below: . ..__..___.__ . . \|\/\|\| \|[__ [ __\|_/ \| \|\|__\|[___[_./\| \
Comment	> Bug in my sqlite 3.6.22 version. > > Horde alarm issues this query: > > SELECT alarm_id, alarm_uid, alarm_start, alarm_end, alarm_methods, > alarm_params, alarm_title, alarm_text, alarm_snooze, alarm_internal > FROM horde_alarms WHERE alarm_dismissed = 0 AND ((alarm_snooze IS > NULL AND alarm_start <= '2012-12-17T16:26:22') OR alarm_snooze <= > '2012-12-17T16:26:22') AND (alarm_end IS NULL OR alarm_end >= > '2012-12-17T16:26:22') AND (alarm_uid IS NULL OR alarm_uid = '' OR > alarm_uid = 'admin') ORDER BY alarm_start, alarm_end > > -> sqlite returns nothing for this. > > If I replace the "T" in the datetime in this query with a simple " ", > sqlite returns the correct result. After returning the correct > result, even the "T" version starts working. > > -> I'll update my sqlite3 version soonish and try again. >
Attachment
Watch this ticket