Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
Hey i am trying to parse data from portal into erp. I used Datetime-local in my html form and when i confirm the record from here it goes to database accurately. Its obvious because my psql shows timezone 'Asia/Karachi'. Its all good till that point but when i come inside erp and check that record it has additional 5+ hours. Y is it so? when my poostgres and odoo both share the same timezone then y i am getting these additional 5 hours?
Kindly help
Try the following code to convert the datetime before passing it to the database:
import pytz
check_time = fields.Datetime.to_datetime(check_time)
local_tz = self.env.user.tz // Timezone of the user
local_dt = pytz.timezone(local_tz)
local_dt = local_dt.localize(check_time, is_dst=None)
check_time = local_dt.astimezone(pytz.utc)
Pass check_time to the database and check the date in Odoo.
Thank you so much, its working now.
Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!
Zarejestruj się| Powiązane posty | Odpowiedzi | Widoki | Czynność | |
|---|---|---|---|---|
|
How to print datetime field Timezone not UTC
Rozwiązane
|
|
3
lip 25
|
3653 | |
|
|
1
sty 24
|
1670 | ||
|
2
lip 22
|
1423 | ||
|
0
sty 20
|
3740 | ||
|
0
maj 22
|
2071 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
