On 2/8/2011 7:42 AM, mike_32 wrote:

Hello!

Recently our Trac was upgraded to 0.12.1 version. After that our custom
reports that contain strftime('%s','YYYY-MM-DD') are not working anymore.

For example:

.... AND TC.time between strftime('%s','2011-01-31') and
strftime('%s','2011-02-05')

When removing those lines, reports give results. Other way reports don't
find any tickets.

Any ideas ?

Not sure what "TC" refers to in the above, but in general time values are now stored as *microseconds* since epoch, no longer as seconds. This might explain your problem.

-- Christian

--
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.

Reply via email to