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? I've
tried various commands with strftime and datetime, but it always returns
garbage. The fields are obviously valid, since they display properly in
the trac reports.
I'd like to format the created field in the ticket database as simply
mm/dd/yyyy, how would I go about doing this? For example the following
doesn't work:
select strftime('%m/%d/%Y', time, 'unixepoch', 'localtime') from ticket;
Thanks,
--
Bill
--
You received this message because you are subscribed to the Google Groups "Trac
Users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/trac-users?hl=en.
