MySQL Forums
Forum List  »  PHP

Re: insert error after updating sql server
Posted by: Barry Galbraith
Date: July 29, 2018 05:45PM

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.

Good luck,

Options: ReplyQuote

Written By
Re: insert error after updating sql server
July 29, 2018 05:45PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.