[Trac-tickets] [The Trac Project] #2219: Bad result from "date(changetime)" in report sql statement

[The Trac Project]

#2219: Bad result from "date(changetime)" in report sql statement
---------------------------+------------------------------------------------
 Reporter:  anonymous      |       Owner:  daniel
     Type:  defect         |      Status:  new   
 Priority:  normal         |   Milestone:        
Component:  report system  |     Version:  0.8.4 
 Severity:  normal         |   Keywords:                 |  
---------------------------+------------------------------------------------
 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

-- 
Ticket URL: <http://projects.edgewall.com/trac/ticket/2219>
The Trac Project <http://trac.edgewall.com/>