how to change datetime zone of postgres from python file..please answer #postgressql 10.9 #odoo12 #python3

Question

When i am saving a expire date time on form data in db by the help of Create( ) of a form as follows at that time db stores an other expire date time..please suggest what to do.. In the form view/Tree view , it shows current date time as input but not in DB.
@api.model  def create(self, vals): otp_value = ''.join(random.choice(string.digits) for _ in range(4))  current_date_time = datetime.datetime.now()  date_time = current_date_time + datetime.timedelta(0,600)  new_record = super().create({'mo

Niyas Raphy (Walnut Software Solutions) · Accepted Answer

Hi,
The thing is that Odoo stores the date-time in the database in UTC time, when it is displayed in the front end, the time will be displayed in the users set timezone. As odoo is multi user system, there will be users in the same database from the different timezones, to make the things easier odoo have used this way.

Suppose if you are here in India, your user
timezone will be Asia/Kolkata , ie, +5:30 UTC. And if you save a
date-time value 26/06/2019 6:30 PM in your custom field, in the data

Nikunja Maharana · Answer

Hii, Niyas Raphy
The thing is that , i am trying to match the current datetime to the stored datetime in python to postgres sql for otp verification ..how should i do ??
thanks in advance..

İlgili Gönderiler	Cevaplar	Görünümler
Expected singleton: hr.emp.travel.location(62, 63) odoo12.0	2 Eki 25	2113
How to write Record Rule with domain based on the company_dependent Fields Çözüldü odoo12.0	3 Eki 23	11009
loan request odoo12.0	1 Eyl 23	4076
sum Colum of based on id odoo12.0	1 May 23	3072
How to make pagination that has a table in qweb odoo12.0	2 Nis 23	3842

Bu soru işaretlendi

@api.model

def create(self, vals):

otp_value = ''.join(random.choice(string.digits) for _ in range(4))

current_date_time = datetime.datetime.now()

date_time = current_date_time + datetime.timedelta(0,600)

new_record = super().create({'mobile_no':vals['mobile_no'],'otp':otp_value,'exp_date_time':date_time}) return new_record

Enjoying the discussion? Don't just read, join in!