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