Hi All, I'm trying to report on some details of check ins.
SELECT DATETIME(r.time, 'unixepoch', 'localtime') AS dt, r.time, nc.base_path FROM revision r INNER JOIN node_change nc ON r.rev = nc.rev WHERE nc.base_path LIKE '%string%'; The 'time' column is stored as an integer which I assume was a unix epoch value. This isn't the case as they all convert to 1413-03-01 13:07:12. DOes anyone know how to conrrectly convert this value? I want the datetime of checkins. Cheers, Rhys -- 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 http://groups.google.com/group/trac-users. For more options, visit https://groups.google.com/groups/opt_out.
