Re: insert error after updating sql server

[Barry Galbraith]

I noticed that your checkDate field is not defined as a DATE type.

Your insert value of "28-07-2018" would be an invalid date if you were using DATE.
It should be YYYY-MM-DD format so the field can be DATE type and you can use MySQL rich set of date handling functions.
String Dates, like you have, are not very useful at all.

https://dev.mysql.com/doc/refman/5.7/en/date-and-time-types.html

Good luck,
Barry.