Setting Oracle date field

[eluser]fszostak[/eluser]
For example, I have a Oracle table with a field type DATE...

Then this table is mapped in a model like this code below.

Mymodel code:

Code:

class My_model extends Model {
    public $MYDATE;

    private function insert() {
        $this->db->insert("MY_TABLE", $this);
    }
}

Mycontroller code:

Code:

$mymodel = new My_model()
$mymodel->MYDATE = '06/08/2010 17:23:45';
$mymodel->insert();

I receive this error: ORA-01830: date format picture ends before converting entire input string.

If you set only date works okay. $mymodel->MYDATE = '06/08/2010';

In Oracle i need put TO_DATE function, but it is dont work in Active Record CI.... i have a lot of codes to make changes, because it is a migration from MySQL.

Thanks for attention.