Hi there,
julianday is not working for me on the MySQL database.
I use this statement:
select t.id as id, t.summary as title, t.changetime as modified from
ticket t where unix_timestamp(DATE_SUB(CURDATE(),INTERVAL 2 DAY)) <=
t.changetime;
This works on MySQL.
johannes
On Aug 6, 11:50 pm, "Mike Kruger" <[EMAIL PROTECTED]> wrote:
> How about something like this:
>
> SELECT (CASE status
> WHEN 'closed' THEN 'color: #777; background: #ddd; border-color: #ccc;'
> ELSE
> (CASE owner WHEN '$USER' THEN 'font-weight: bold' END)
> END) AS __style__,
> id AS ticket, summary, status as _status,
> time AS _time,reporter AS _reporter
> FROM ticket t
> WHERE ((julianday('now') - julianday('1970-01-01')) - changetime/86400) < 7
> ORDER BY (status = 'closed'), changetime DESC
>
> mike
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
