3

I am trying to make modified time appear on trac report so I added change time to the sql query but now all I am getting is a long number in the modified column why?

Mir Khashkhash
  • 399
  • 2
  • 4
  • 7

1 Answers1

4

try this :

select date(changetime, 'unixepoch') from ticket

from http://trac.edgewall.org/ticket/2219

Since 0.12 trac uses microsecond timestamps, so you have to specify:

select date(changetime / 1000000, 'unixepoch') from ticket
wimh
  • 15,072
  • 6
  • 47
  • 98
Max
  • 4,152
  • 4
  • 36
  • 52