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 IT) · 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..

Related Posts	Replies	Views
How to write Record Rule with domain based on the company_dependent Fields Solved odoo12.0	3 Oct 23	5973
loan request odoo12.0	1 Sep 23	1962
sum Colum of based on id odoo12.0	1 May 23	1000
How to make pagination that has a table in qweb odoo12.0	2 Apr 23	1374
Inherit Element form kanban View Solved odoo12.0	1 Mar 23	996

This question has been flagged

@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!