Trac automatically processes certain column names in the query results. Anything named "created" is parsed as an epoch timestamp. Just do "as datecreated" or something.
--Noahg > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] > On Behalf Of patrick > Sent: Tuesday, September 16, 2008 3:14 AM > To: Trac Users > Subject: [Trac] Datetime in sql > > > Hi all, > > I want to save a report as csv file with datetime format m-d-y in > stead of 2006-09-18T15:55:04Z+0200 > > I searched in the trac-user group and found this: > datetime(time, 'unixepoch', 'localtime') AS created, > > but then I got the following error: > > ValueError: invalid literal for int() with base 10: '2006-09-18 > 15:53:37' > > File "C:\Program Files\Python25\lib\site-packages\trac\ticket\templates > \report_view.html", line 120, in <Expression u"cell.value != 'None' > and format_date(int(cell.value)) or '--'"> > <td class="date" py:attrs="td_attrs">${cell.value != 'None' and > format_date(int(cell.value)) or '--'} > > I read also the sql manual > http://www.sqlite.org/lang_datefunc.html but those function are not > working > > I'm using: > Trac: 0.11.1 > Python: 2.5.2 (r252:60911, Feb 21 2008, 13:11:45) [MSC v.1310 32 > bit > (Intel)] > setuptools: 0.6c8 > SQLite: 3.3.4 > pysqlite: 2.3.2 > Genshi: 0.5.1 > mod_python: 3.3.1 > Subversion: 1.4.6 (r28521) > jQuery: 1.2.6 > > > How can I solve this? > > Thanks > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
