how to insert a date into the database?

[eluser]NateL[/eluser]
First, You posted in the job board. Post in the right section next time ;-)

Onto your question...
You could use the date() function:

Code:

<?php
echo date('m-d-Y');  // outputs 09-19-2009
?>

so on your insert statement, it would look something like this:

Code:

$date = date('m-d-Y');
$this->db->insert('mytable', $date);

If you want more control, down to the second, you could use Epoch time. Look on the php.net manual for the time() function.