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')*

Bài viết liên quan	Trả lời	Lượt xem
Change tzinfo to a specific datetime field in Odoo v13 or v14 datetime odoo	1 thg 5 22	5926
Set default time for datetime field odoo 11 default time datetime odoo odoo11	1 thg 8 21	7895
Set time default in Datetime odoo 11 Đã xử lý time datetime replace odoo odoo11	1 thg 8 21	5734
Datetime display wrong time in odoo datetime odoo	1 thg 8 21	6476
Show Only Time From Datetime in QWeb Report Đã xử lý time datetime qweb-report	2 thg 3 24	2633

Câu hỏi này đã bị gắn cờ

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!