I want to updated time value in float field from datetime field by psql query odoo 14. So, i can i get this.
My code is below:
start_datetime = fields.Datetime("Start DateTime", required=True) duration = fields.Float('Duration', readonly=True) def init(self): '''Create the view''' tools.drop_view_if_exists(self._cr, self._table) self._cr.execute(""" CREATE OR REPLACE VIEW %s AS ( SELECT ROW_NUMBER() OVER() as id, aal.start_datetime as start_datetime, (start_datetime at time zone 'utc') ::timestamp as duration --Try to update above duration field with time only from account_analytic_line aal left join project_project pro on pro.id = aal.project_id )""" % (self._table,))
Thanks in advance.