Hi,
I am using a postgres db and I am trying to select specific changed
states that occur today.
SELECT id AS ticket, status, summary
FROM ticket
WHERE status IN ('new', 'closed', 'reopened')
/* AND THE ABOVE STATE CHANGES OCCCURRED TODAY */
I think I am having issues comparing a unix timestamp with current_date
Is it possible also to COUNT the number of results returned?
Aidy
--
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.
