Odoo Help


Time spent between 00:00:00 and 01:59:59 appear on the day before

on 7/23/14, 9:41 AM 1,703 views


When declaring time spent over task. I figured out that if the time of the date on which we declare the time is comprised between  00:00:00 and 01:59:59 (included) then the time declared appear on rthe day before when looking at "Reporting>Timesheet analysis"

Example: 2 hours entered on a task at the date October, 5th at 01:15:00 appear in the report as 2 hours spent on the October 4th.

This is not coherent and is priobably not the expected behaviour.

I can not force my users to specifiy a time (we do not care at which time exactly was the task done). How to tackle this issue? Raise a bug ? And if se, how to make it ?

I am on v8 RC1 on Ubuntu server 14.04. Can anybody reproduce this ?







| 5 4 6
Zagreb | Karlovac, Croatia

there is only 10 kind of people the ones that understand binary ... and others

On 7/25/14, 4:06 AM

Time zones and server setup is the topic you should read about.. 
Short version: server should always be in UTC time, users should have time zone set up corectly,
Server will always write time and datetime records in UTC without timestamp... and recalculate in current user timezone on view rendering.

My guess is that your server time is something like GMT +1 or GMT+2 ( or any timezone with this characteristic)... 
To check that info, go to console and type: date +%Z  
and if it is not UTC you can change it by typing : sudo dpkg-reconfigure tzinfo


read more on this subject 

On 7/27/14, 4:07 AM

Thanks for having taken the time to answer.

I set the server timezone as UTC as suggested. This may impact the postgresql server timezone which use by default the server's one (timezone = 'localtime' in the postgresql config file).

-> The problem is still present

I also changed the config file of postgresql from timezone = 'localtime' to timezone = 'UTC' and results are the same

Practical example based on my current configuration:


The server is set as UTC, the postgresql is set as the server, the user's client is in CEST (UTC+2) and the users' timezone preference is set as Europe/Paris in OpenERP.

In that configuration, entering a time record in task on the 26/06/2014 00:00:00 makes it appearing on the 25/06/2014 in the timesheets and create a record in the table project_task_work at 25/06/2014 22:00:00.

The record in the DB looks OK (-2 hours compared to what I entered which corresponds to the time difference between user local time (CEST) and UTC time. The issue looks like to be when generating the timesheets.


I also looked at the links you provided: they relate to comparable issues but none of them was solved, except by using unsatisfying local patches.



I opened an 'issue' on github and it is likely to be confirmed as a bug. See here: https://github.com/odoo/odoo/issues/1349#issuecomment-50278551

on 7/28/14, 3:27 AM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 7/23/14, 9:41 AM
Seen: 1703 times
Last updated: 3/16/15, 8:10 AM