Setting NULL value in date and time

Need Help
1

Hi all,

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
UPDATE task
SET date_completed=NULL
WHERE id=112

Thanks everyone!
Craig