[Trac-tickets] Re: [The Trac Project] #2007: Allow to specify time intervals in reports

[The Trac Project]

#2007: Allow to specify time intervals in reports
---------------------------+------------------------------------------------
 Reporter:  ula            |        Owner:  daniel    
     Type:  enhancement    |       Status:  closed    
 Priority:  normal         |    Milestone:            
Component:  report system  |      Version:  devel     
 Severity:  major          |   Resolution:  worksforme
 Keywords:                 |  
---------------------------+------------------------------------------------
Changes (by mgood):

  * status:  new => closed
  * resolution:  => worksforme
  * milestone:  1.0 =>

Comment:

 Please see the [http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
 SQLite documentation on date time functions] for how to use them in your
 report.

 Note that the Trac timestamps are in Unix format, so you can use a where
 clause like this for your example above:

 {{{
 #!sql
 where datetime(ticket.time, 'unixepoch')
     between '2005-08-10' and '2005-08-20'
 }}}

-- 
Ticket URL: <http://projects.edgewall.com/trac/ticket/2007>
The Trac Project <http://trac.edgewall.com/>