How to set a datetime field = now() during insert? I'm using db_insert() to insert a record into a table. That table as a "creationDatetime" field which should be set to now() on insert. I tried setting it to REQUEST_TIME, but that value is a unixtime value and not an sql datetime format so I get an error.

I suppose I could write a php function that will automatically format REQUEST_TIME as an sql datetime value and call that function every time I try to insert, but does anyone else have a better solution?
Using a slightly different syntax (drupal_write_record):

$new_record = array(
    'field' =&gt; $form_state['values']['field'],
    'timestamp' =&gt; date("Y-m-d H:i:s", time()), //&lt;- this
);          
drupal_write_record('table_name', $new_record);