I am having a hell of a time generating a report with dates of creation for my tickets. here is my sqlite query .header on .mode csv .output opentickets.csv SELECT DISTINCT id AS ticket, summary, status, priority, t.type AS type, owner, time as created FROM ticket t, ticket_custom q LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority' WHERE t.id = q.ticket AND status <> 'closed' ORDER BY priority, time; But the value I get for the time of creation is garbage: I get 1341324096360000 when I should get 2012-07-03 I have tried unix epoch time conversion but then I get query: .header on .mode csv .output opentickets.csv SELECT DISTINCT id AS ticket, summary, status, priority, t.type AS type, owner, datetime(time, 'unixepoch') as created FROM ticket t, ticket_custom q LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority' WHERE t.id = q.ticket AND status <> 'closed' ORDER BY priority, time; I get: -1413-03-01 13:07:12
-- You received this message because you are subscribed to the Google Groups "Trac Users" group. To view this discussion on the web visit https://groups.google.com/d/msg/trac-users/-/epW3vhY-d34J. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
