Siirry sisältöön
Menu
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Tämä kysymys on merkitty
2 Vastaukset
3820 Näkymät

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
Hylkää
Tekijä

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

Paras vastaus

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
Hylkää
Paras vastaus

In database, columns said "Timestamp without time zone"

Avatar
Hylkää
Aiheeseen liittyviä artikkeleita Vastaukset Näkymät Toimenpide
9
kesäk. 23
13018
2
jouluk. 21
7845
0
kesäk. 21
1910
0
helmik. 21
2510
0
helmik. 21
4288