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
signature.asc
Description: OpenPGP digital signature
