[Tickets #12637] Horde_Alarm: Unify date formats / fix _list() for sqlite

[noreply at bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/12637
------------------------------------------------------------------------------
  Ticket             | 12637
  Created By         | Thomas Jarosch <thomas.jarosch at intra2net.com>
  Summary            | Horde_Alarm: Unify date formats / fix _list() for
                     | sqlite
  Queue              | Horde Framework Packages
  Version            | Git master
  Type               | Bug
  State              | Unconfirmed
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


Thomas Jarosch <thomas.jarosch at intra2net.com> (2013-08-28 21:37) wrote:

Hi,

Horde_Alarm currently mixes ISO-8601 dates ('2013-08-28T18:08:48')
and dates formatted like this '2013-08-28 18:08:48'.

This breaks for sqlite since it does not have a designated datetime type,
it just compares datetime as strings[1].

[1] http://www.mail-archive.com/sqlite-users@sqlite.org/msg78962.html


Attached patch makes sure we stick to just one date format.
This fixes the horde-alarms script for me.

Cheers,
Thomas