Comment 2 for bug 1255612

Holger

I am doing checking for issues I should know before my installation of OE is in full production.

FYI: OE is using UTC in the DB like you might know and this is as it should be. It also means that server OS has to use same (as they mostly do). See

In theory any usage of date or time in OE should have:
1. Correct "datetime" in / out handling: UTC -> Local TZ, Local TZ -> UTC.
2. There should be handling for "datetime" in reports, screens, interfaces so that user gets correct TZ, but also Customers, Suppliers, Multi-Companies, Banks (e.g. eInvoicing) etc who might receive data gets correct TZ.

You are not alone:
https://bugs.launchpad.net/openobject-addons/+bug/1179893
https://bugs.launchpad.net/openobject-server/+bug/1155843
https://bugs.launchpad.net/openobject-addons/+bug/1219845

My proposal is that you link your Bug to these.

And discussions about these TX issues:
http://help.openerp.com/question/31908/how-to-get-attendance-be-assigned-to-the-correct-day-for-anyone-who-is-not-in-the-utc-timezone/

http://help.openerp.com/question/20105/timezone-issue-in-openerp-70-version/

http://help.openerp.com/question/17404/is-there-a-workaround-for-the-bug-where-timesheet-entries-use-incorrect-timezone/

One part solution here:
http://help.openerp.com/question/17404/is-there-a-workaround-for-the-bug-where-timesheet-entries-use-incorrect-timezone/

TZ is an old source of issue for OE - now TZ issues are not anymore trivial for average designers to realize.
http://forum.openerp.com/forum/topic34520.html

Hopefully this helps you Holger to see picture and hopefully I am totally wrong with this educated guess that this TZ issue is lurkingg here and ether.

PS: TZ, Character Set, Currencies, and other i18n & L10n issues are hard to solve one and for all. Most of designers does understand their own and OS defaults, but it is not easy to see the big picture. Starting guide for the issues: http://en.wikipedia.org/wiki/Internationalization_and_localization

PS2: Luckily Linus Thorvalds (Linux) & Monty Widenius (MySQL, MariaSQL) are both boldy & bi-langual Finns, so they have done more than average developer to boost the big journey to have some day i18n and L10n solved. Only 30 years has passed to this level :-)

BR Harri from snowy and cold Finland (-20 Degrees Celsius) to hot Australia :-) and Holger to warm NL