In the continuing saga of my 'inherited' Trac server... Some of the reports are using 'time' or 'changetime', inside a datetime function, like:
datetime(time,'unixepoch') as 'Date Created' Unfortunately, it appears that the times in the database are microseconds since unixepoch, so I get some very odd results. The most-obvious fix is to change the report(s) to use: datetime(time/1000000,'unixepoch') as 'Date Created' However, I'm wondering if I really should be doing that. First, there are dozens of reports like this. Obviously at one time, the time was stored in seconds. Did something change between Trac 0.12 and 1.2.3 so that times in the database were changed to microseconds instead of seconds? (e.g. something in the 'upgrade' process? Or is something else going on? If times changed due to 'upgrade' -- shouldn't 'upgrade' also modify the reports or at least provide a warning? :) -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/trac-users. To view this discussion on the web visit https://groups.google.com/d/msgid/trac-users/5256c1da-75b4-44f6-b09c-749479d48800%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
