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

Post Terkait	Replies	Tampilan
Expected singleton: hr.emp.travel.location(62, 63) odoo12.0	2 Okt 25	2101
How to write Record Rule with domain based on the company_dependent Fields Diselesaikan odoo12.0	3 Okt 23	10992
loan request odoo12.0	1 Sep 23	4071
sum Colum of based on id odoo12.0	1 Mei 23	3069
How to make pagination that has a table in qweb odoo12.0	2 Apr 23	3838

Pertanyaan ini telah diberikan tanda

@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

Menikmati diskusi? Jangan hanya membaca, ikuti!