Why I cant set duration field to zero instead it shows an error pymysql.err.DataError: (1366, "Incor

Hello Everyone,
when I type non-zero values in the duration field, it shows an empty value, but when I select the value from the dropdown, the value is shown and saved.
When I update non-zero values to zero values by selecting a value from the dropdown or type zero in that duration field it shows an error:
pymysql.err.DataError: (1366, “Incorrect decimal value: ‘’ for column _5f4f1ee02e32187a.tabdurationdata.durate_time at row 1”)
And also another error also occurs
pymysql.err.DataError: (1265, “Data truncated for column ‘durate_time’ at row 1”)

Anyone have solution for this?

Delete the field and again recreate the field.

If you add custom field from the customize form then trim table.

still facing the same issues

Last option:

Please check the reference:

Not working in duration field