Try ERPNext Buy Support Partners Foundation

Healthcare: Patient_appointment

The below error is show due to date conversion

Traceback (most recent call last):

  File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/", line 102, in execute_job
  File "/home/frappe/frappe-bench/apps/erpnext/erpnext/healthcare/doctype/patient_appointment/", line 333, in set_appointment_reminder
    remind_before = datetime.datetime.strptime(frappe.db.get_single_value("Healthcare Settings", "rem_before"), '%H:%M:%S')
  File "/usr/lib/python3.6/", line 565, in _strptime_datetime
    tt, fraction = _strptime(data_string, format)
  File "/usr/lib/python3.6/", line 365, in _strptime
ValueError: unconverted data remains: .909578

Why not convert to 
datetime.datetime.strptime(frappe.db.get_single_value('Healthcare Settings','rem_before'),'%H:%M:%S.%f').strftime('%H:%M:%S')

Care to share version, steps to reproduce?

ERPNext: v12.14.0 (version-12)

Frappe Framework: v12.12.0 (version-12)

No steps to reproduce as this runs on the background tasks… But if you have health care domain active and try on console
datetime.datetime.strptime(frappe.db.get_single_value(“Healthcare Settings”, “rem_before”), ‘%H:%M:%S’)
It will return the error if field rem_before has a time with nanoseconds.