With an Oracle database, timecharts generates the following error (in catalina.out): (ORA-01861: literal does not match format string) for the query: 2008-05-05 12:08:00,111 http-8080-Processor17 ERROR [jira.plugins.timecharts.TimeChart] org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:select changegroup.CREATED, jiraissue.pkey, changeitem.FIELD, changeitem.OLDVALUE, changeitem.OLDSTRING, changeitem.NEWVALUE, changeitem.NEWSTRING, changeitem.FIELDTYPE from changegroup, changeitem, jiraissue where changegroup.ID=changeitem.groupid and changegroup.issueid=jiraissue.ID and changegroup.CREATED > '2008-03-26 00:00:00' and changeitem.FIELD in ('assignee','Project','issuetype','status','PDESimple PROD PRODUCT') order by changegroup.CREATED desc (ORA-01861: literal does not match format string ) The format of the changegroup.CREATED clause should be: "changegroup.CREATED > to_date('2008-03-26 00:00:00', 'yyyy-mm-dd hh24:mi:ss') "