MySQL Forums
Forum List  »  Newbie

Re: Still Having Problems with DATE....
Posted by: Raymond Jender
Date: June 20, 2021 05:03PM

So I changed TYPE to DATE.

Before the query, the date format is
echo nl2br("surveyduedate = $surveyduedate\n");

$surveyduedate = 2021-06-29 (I thought this is the correct format for mysql?)

After the query I'm getting this error:
Fatal error: Uncaught mysqli_sql_exception: Incorrect date value: '1986' for column 'surveyduedate' at row 1

I appreciate your help with this.

Ray

Options: ReplyQuote


Subject
Written By
Posted
Re: Still Having Problems with DATE....
June 20, 2021 05:03PM


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.