Hi, those numbers are UNIX timestamps. You can format them as a date and time using some DB built-in functions.
In case you use SQLite (the default for Trac), you can do as follows: wherever you read "changetime" in your report, replace with: datetime(changetime/1000000, 'unixepoch') You can find a full set of functions and options in the SQLite documentaiton: http://www.sqlite.org/lang_datefunc.html Ciao, Roberto 2012/3/21 Helen <[email protected]> > Hello everyone. I'm using Trac 0.12, and my question is: what value > exactly ticket.time and ticke.changetime return? I selected > changetime and it returned value as "1331537781158000". > > I just wanted to get how long before the ticket was modified. And I'm > using the following scripts I got from trac.edgewall.org: > > SELECT p.value AS __color__, > t.owner AS __group__, > t.type, > id AS ticket, summary, component, version, t.severity AS severity, > (CASE status WHEN 'assigned' THEN owner||' *' ELSE owner END) AS > owner, > (CASE WHEN round(time.now*1000000 - changetime) > 86400 > THEN round((time.now*1000000 - changetime)/86400.0) || ' days' > WHEN time.now*1000000 - changetime > 3600 > THEN round((time.now*1000000 - changetime)/3600.0) || ' hours' > ELSE round((time.now*1000000 - changetime)/60) || ' mins' > END) AS LastModified, > description AS _description, > reporter AS _reporter, > milestone AS _milestone > FROM ticket t , > enum p, > (SELECT current_timestamp as now) time > WHERE p.name = t.priority AND p.type = 'priority' > ORDER BY t.owner, changetime desc, p.value, t.severity, time > > However, the "LastModified" returned a wired minus value for me. Could > anyone pls help? I've been working on this for a whole day. Thanks a > lot. > > Helen > 2012.3.21 > > -- > 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. > > -- 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.
