Odoo(V12) ValueError: time data '2019-10-08 18:60:00' does not match format '%Y-%m-%d %H:%M:%S'

Question

Hey all! I am facing this issue while using strptime. But as i can see in my code i am unable to find what i am doing wrong kindly please help with these 3 lines. error is generated from "new_date"

new_date_time = str(day_dict[0].date) + ' ' + hour
new_date = datetime.strptime(new_date_time, '%Y-%m-%d %H:%M:%S')
self.create_inverse_attendance(day_dict[0].employee_id, action, new_date)

Niyas Raphy (Walnut Software Solutions) · Accepted Answer

Hi,
It seems the date time value is wrong, in the error message it can be seen that your date time is 2019-10-08 18:60:00 , which actually it has to be 2019-10-08 19:00:00 , * 60 Minutes has to be counted as an hour right * ?
You are getting the error message because in the date time format, * the value for %M is 0-59 *
Thanks

cesar mateo · Answer

The date you are trying to convert "2019-10-08 18:60:00", in the hour you have the minute 60, which is not correct since it only corresponds to 0-59, for example:
*new_date = datetime.strptime('2019-10-08 18:59:00','%Y-%m-%d %H:%M:%S')*

Related Posts	Відповіді	Переглядів
Change tzinfo to a specific datetime field in Odoo v13 or v14 datetime odoo	1 трав. 22	6617
Set default time for datetime field odoo 11 default time datetime odoo odoo11	1 серп. 21	8548
Set time default in Datetime odoo 11 Вирішено time datetime replace odoo odoo11	1 серп. 21	6218
Datetime display wrong time in odoo datetime odoo	1 серп. 21	7302
Show Only Time From Datetime in QWeb Report Вирішено time datetime qweb-report	2 бер. 24	3416

Це запитання позначене

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