I am trying to clear a DATE or a DATETIME value in MySQL. More specifically I am trying to set it to NULL. For some reason it will not set the DATE or DATETIME to NULL in MySQL.
In my controller I have the following code…
$this->request->data[‘date_completed’] = null;
Note: The date_completed field in MySQL is set to allow NULL.
The following code works in MySQL