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..

Related Posts	Replies	Views
Expected singleton: hr.emp.travel.location(62, 63) odoo12.0	2 okt. 25	2286
How to write Record Rule with domain based on the company_dependent Fields Solved odoo12.0	3 okt. 23	11494
loan request odoo12.0	1 sep. 23	4303
sum Colum of based on id odoo12.0	1 maj 23	3207
How to make pagination that has a table in qweb odoo12.0	2 apr. 23	4030

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!