I want to know how Odoo manages the different timezones and date format for the Backend and PDFs
Version: 19
Related forum post: Format Dates in PDF based on Customer Timezone and Language
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- 客户关系管理
- e-Commerce
- 会计
- 库存
- PoS
- 项目
- MRP
此问题已终结
1
回复
315
查看
Backend
Datetime fields shown in the backend consider the timezone set in your device (ex. the computer you are working on).
Timezone in Computer | Backend field |
Mexico City, Mexico |  |
Tokyo, Japan |  |
The date and time format is taken from the user language:
Language | Setting |
Spanish (Latin America) / Español (América Latina) |  |
English (US) |  |
💡
Odoo saves the datetime field value in UTC time, but when you see it in Odoo, the time is "converted" based on your device timezone and with the user language format.
When using filters, you should put your specific time, and Odoo will look for the field raw value (in UTC).
You can also do some other configurations using Studio, like showing the month in numbers or name, or choosing whether or not to show hours or seconds.
When we add a datetime field to a PDF Report using the "/" command, the time shown considers the user timezone when downloading the PDF.
The date and time format is taken from the user language
Examples:
User Language | User Time zone | Result in the PDF Report |
Spanish (Latin America) / Español (América Latina) | Mexico City, Mexico |  |
Spanish (Latin America) / Español (América Latina) | Tokyo, Japan |  |
English (US) | Tokyo, Japan |  |
English (US) | Mexico City, Mexico |  |
PDF (Advanced)
If you edit the source code of the PDF Report, you will see that the field was added with a t-field.
In case we use t-out/t-esc instead of t-field, the PDF will show the time in UTC, ignoring any language format we talked about earlier.
If you want to format the datetime, you could do it as follows:
For showing only date using t-field or t-out:
<span t-field="doc.x_studio_datetime" t-options="{'widget': 'date'}"/>For custom date and time format using t-out or t-esc:
<span t-out="doc.x_studio_datetime.strftime('%d/%b/%Y %I:%M %p')"/>Date components | Time components | ||||||||||||||||||||||||||||||||
|
|
Week / Weekday | Quick preset | ||||||||||||||||||||||
|
|
Artificial Intelligence
For AI fields, if you add a prompt specifying a certain hour/time, it will be set in UTC. But when you see it in the backend, it will be shown in your device timezone. Example:
Prompt | Result in Odoo Backend for Mexico City timezone |
 |  |
You could also take other datetime fields for the AI prompt
Prompt | Result in Odoo Backend |
 |  |
Extra: contacts timezone
By default, contacts are generated with the timezone of the user that creates it.
You can see the timezone for each contact by showing the field using Studio.
Moreover, you can also add the field that shows the difference between UTC and the selected timezone for that contact.
| 相关帖文 | 回复 | 查看 | 活动 | |
|---|---|---|---|---|
|
|
1
11月 25
|
303 | ||
|
2
10月 25
|
33760 | ||
|
2
10月 25
|
994 | ||
|
1
11月 25
|
1523 | ||
|
0
8月 25
|
1510 |
