id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc,branch,changelog,apichanges,internalchanges 2219,"Bad result from ""date(changetime)"" in report sql statement",anonymous,daniel,"The following SQL statement in my report produces a incorrect output for the date of the changetime field: SELECT id AS ticket, date(changetime) AS 'Date Closed', summary, component, time AS created FROM ticket WHERE status = 'closed' ORDER BY changetime DESC For example, the 'Date Closed' column in the report will contain ""3086946-03-20"" for the date, expecting something like ""2005-10-13"". When using ""SELECT id AS ticket, changetime AS 'Date Closed'"" instead, the result is ""1129205013"", which is expected for a Unix Timestamp. Cheers, Bruce Clark SAIC 410-865-7661",defect,closed,normal,,report system,0.8.4,normal,worksforme,,,,,,