Error when INSERT empty date on MySQL field with Active Record

[eluser]Madmartigan1[/eluser]
Cast the value to integer.

Code:

$data['event_date'] = (integer) $this->input->post('event_date');

It will default to 0 if the value is empty.

EDIT: Sorry I use unix timestamps, I'm actually not familiar with the MySQL "date" type. I didn't read your post thoroughly.