Zum Inhalt springen
Menü
Sie müssen registriert sein, um mit der Community zu interagieren.
Diese Frage wurde gekennzeichnet
2 Antworten
3775 Ansichten

When i export data, like field Deadline, I have date and time data, it show on file excel wrong Time that it -7 hours ( my local time is GMT + 7 ). Can I change this? I want it show on file excel directly with data in my field on odoo. It make my report isn't right for my boss to see.

Avatar
Verwerfen
Autor

I know this, but do we have some way to make this possible? Get directly data from field in odoo to excel?

Beste Antwort

All datetime information is exported in the UTC timezone, no matter your local timezone. This is so all Users anywhere in the world can collaborate. If your Business Support team in San Jose, California extracts data and sends it to the New York City office to be updated who then sends it to the London office, the only way this works is with a common underlying timezone. By using UTC we prevent any data corruption due to a User importing data while in a different timezone than the User who exported it. 

Avatar
Verwerfen
Beste Antwort

In database, columns said "Timestamp without time zone"

Avatar
Verwerfen
Verknüpfte Beiträge Antworten Ansichten Aktivität
9
Juni 23
12961
2
Dez. 21
7746
0
Juni 21
1848
0
Feb. 21
2469
0
Feb. 21
4255