Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
I am developing odoo8 in a windows pc with eclipse and pydev.
My problem is datetime generated with fileds.Datetime.now() is local time (not UTC time).
Also, relevant field data in PostgreSQL database is local format (but reserved fields in database like create_date and write_date are in UTC format)
This makes datetime fields showing in UI wrong.
What is the root cause?
Hello,
The idea is to always stock date in utc in database.
And display it in the timezone of the current user...
So in the ui, you will see the date from db + the lambda of your timezone.
You are right, and i am aware of that. My problem is that I get date in database in local time format, NOT a naive UTC time. For example, i have a Datetime field, and the local time in China now is 22:00. After i write this field to fields.Datetime.now() programmatically, I get 22:00 in the database, NOT 14:00 . Another weird thing is, write_date field of this record is 14:00 (RIGHT UTC time, and create_date field will always be correct).
Check if the user's timezone is set to UTC? settings -> users -> [user] -> preferences (tab)
Check if the postgres database timezone is correct:
SELECT current_setting('TIMEZONE') TZ;
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
3
Jun 25
|
1962 | ||
|
1
Jul 23
|
4762 | ||
|
4
Dec 22
|
10525 | ||
|
2
Apr 21
|
4483 | ||
|
1
Oct 18
|
5907 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
