Something

2006-12-28 19:11:18,556 Trac[__init__] DEBUG: Executing report with SQL "SELECT id as ticket, summary, component, c.value as location, t.type AS type,   status, time AS createdFROM ticket t  LEFT OUTER JOIN ticket_custom c ON (t.id = c.ticket AND c.name = 'location')WHERE t.time BETWEEN EXTRACT(EPOCH FROM TIMESTAMP ''||%s||' 00:00:00') AND EXTRACT(EPOCH FROM TIMESTAMP ''||%s||' 23:59:59')ORDER BY time ASC, location, type" ([u'2006-01-01', u'2006-12-31'])