Thanks. That worked. Interesting that they would choose to use
microseconds. Milliseconds I can understand, but that's some pretty fine
precision there.
On 5/9/2011 6:20 PM, Remy Blank wrote:
Bill Buklis wrote:
I'm need to do some external queries to the trac database, so I'm using
sqlite directly. What format are the various date/time fields in?
They are microseconds since the epoch.
select strftime('%m/%d/%Y', time, 'unixepoch', 'localtime') from ticket;
You just need to convert the microseconds to seconds. The following
should work:
SELECT strftime('%m/%d/%Y', time / 1000000, 'unixepoch', 'localtime')
FROM ticket;
-- Remy
--
Bill
--
You received this message because you are subscribed to the Google Groups "Trac
Users" group.
To post to this group, send email to trac-users@googlegroups.com.
To unsubscribe from this group, send email to
trac-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/trac-users?hl=en.
