Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
Hi community, I have this problem with odoo:
I installed odoo on MS Windows 2008 Server R2 and I configured the time zone correctly in my OS and Odoo Web too.
But, the problem is: when an employee let's do a check in or check out, at the database appears a wrong hour, but in the website appears good.
Example 1: A employee did a check in at 08:00 AM, but in the database appears 12:00 PM
Example 2: I create a new employee at 12:00 PM, but in the database appears 16:00 PM
How can I to repair this problem ?
There is no problem - this is how Odoo is designed to work.
Odoo stores ALL times and dates in UTC, not the local timezone.
It may be 12pm in Chile, but this time will be stored in the database as 4pm - because Chile is 4 hours behind UTC.
This is so Odoo can work with clients in any timezone - and they can all be correctly interpreting dates.
It also means if someone exports a file in Chile and send it to Belgium - the dates and times imported will be correct, relative to the local timezone - because the export will ALSO be in UTC.