Add a report formatting option to format timestamps

[ebrown@…]

Based on the code in source:/trunk/trac/ticket/report.py​ it appears that a subset of 4 fields are automatically formatted as date strings. I am not sure what formatting option you can make available (already use _ and __ etc) but it would be nice to be able to dictate what columns are formatted. As far as I can tell SQLite does not include date formatting in their SQL functions. Probably an easy fix.

(for reference, I am trying to add the last comment date).

[Christopher Lenz]

Not for 0.9.

[Matthew Good]

#2057 has been marked as a duplicate of this ticket.

[sawtelle@…]

Is this related to the problem of "Datetime(changetime, 'unixepoch') AS modified" resulting in a column title of "Datetime(changetime, 'unixepoch')" rather than "Modified"?

[Christian Boos]

It could be interesting to have a way to add a post-processing step for dates that would ease the differences between different SQL date formatting syntaxes, so maybe a _date_... prefix could be used.

Another possibility would be to use real date columns (as suggested in #3935) in the hope that a common SQL subset can be used to manipulate them (MySQL as usual seems to have its own ways to deal with dates).