Hello Christoph,
AND time >= EXTRACT (EPOCH FROM TIMESTAMP '2007-03-01 00:00:00')
AND time <= EXTRACT (EPOCH FROM TIMESTAMP '2007-03-31 23:59:59')
I use this piece in the WHERE clause of my reports to look for all
tickets that were created in February. We use PostgreSQL for our Trac
queries (I'm not sure if this is standard for Trac).
On Mar 19, 8:54 am, "Christoph Baudson (WhereGroup)"
<[EMAIL PROTECTED]> wrote:
> Hello,
>
> My name is Christoph and I'm using Trac for Mapbender, see
> trac.osgeo.org/mapbender/
>
> I have a question about creating reports; I checked
>
> http://trac.edgewall.org/wiki/TracReports
>
> but didn't find what I was looking for.
>
> I want to retrieve all issues created after a certain date. What is the
> correct where-condition? I have to use some ">" operator, but don't know
> exactly how.
>
> Any help is highly appreciated!
>
> --
> Baudson Christophhttp://www.wheregroup.com
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
