Timezone issue in odoo Datetime V13

Question

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

Sudhir Arya (ERP Harbor Consulting Services) · Accepted Answer

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.

相關帖文	回覆	瀏覽次數
How to print datetime field Timezone not UTC 已解決 timezone UTC	3 7月 25	3569
Formatted date time field depending on timezone timezone UTC	1 1月 24	1628
when mass loading , the date is backing up 1 day from what is loaded timezone Odoo13.0	2 7月 22	1392
odoo13 : Database creation error postgresql Odoo13.0	0 1月 20	3712
psycopg2.ProgrammingError: can't adapt type 'dict' postgresql odoo Odoo13.0	0 5月 22	2045

此問題已被標幟

喜歡這則討論？不要只閱讀，加入發表意見吧！