Hello,
I want to create a ticket that shows all the closed defects ordered
by modification date. The following one works:
SELECT id AS ticket, owner,
time as created, changetime as closed, summary FROM ticket
WHERE status IN ('closed')
ORDER BY changetime
but it shows a the changetime as a number (for example 1153755339).
How do i convert it to a date?
How does this report do it?
http://dev.openguides.org/report/9
Thanks!
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac
Users" group.
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
-~----------~----~----~----~------~----~------~--~---
