I have something like this going right now. Decided I was going to try
and do it in hours and then work it to days
strftime('%s','now') - strftime('%s','changetime') / 3600
That doesn't seem to work at present although I am pretty sure that it
should.
On Sep 28, 2:30 pm, Erik Bray <[email protected]> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
