Hello Christian, could u perhaps give an example of the new syntax based on the query from mike?
thx in advance ~eike On 02/08/2011 09:12 AM, Christian Boos wrote:
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
-- Eike Jordan <[email protected]> | FIZ CHEMIE BERLIN | Franklin Str. 11 ------ ,__o | 10587 Berlin ------ _-\_<, | ------ (+)/'(+) | Tel. : 0049-30-39977 214 -- 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.
