[FIX] project: use utc timezone in report
authorMartin Trigaux <mat@odoo.com>
Tue, 21 Oct 2014 13:15:50 +0000 (15:15 +0200)
committerMartin Trigaux <mat@odoo.com>
Thu, 23 Oct 2014 06:58:37 +0000 (08:58 +0200)
addons/project/report/project_report.py

index 7bd8b82..9493005 100644 (file)
@@ -87,7 +87,7 @@ class report_project_task_user(osv.osv):
                     planned_hours as hours_planned,
                     (extract('epoch' from (t.write_date-t.create_date)))/(3600*24)  as closing_days,
                     (extract('epoch' from (t.date_start-t.create_date)))/(3600*24)  as opening_days,
-                    (extract('epoch' from (t.date_deadline-now())))/(3600*24)  as delay_endings_days
+                    (extract('epoch' from (t.date_deadline-(now() at time zone 'UTC'))))/(3600*24)  as delay_endings_days
               FROM project_task t
                 WHERE t.active = 'true'
                 GROUP BY