On Sun, Sep 27, 2009 at 1:43 PM, zdgman <[email protected]> wrote: > > Hello All, > > I am trying to get the lastmodified column in this query on the Trac > Dev Site > > http://trac.edgewall.org/report/20 > > I know how to create lastmodified as a date but can't seem to get it > listed out as a day's since last updated. Would it be possible for me > to see the SQL query from the edgewall site? > > Thanks.
If you want the number of days since the ticket was last modified, that's just simple math: Take the current date/time as a unix timestamp, subtract the modified time, and divide by (3600 * 24). --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
