Hi Tony, Try using Zend_Db_Expr for your MySQL function calls. This is documented, but it lacks prominence:
http://framework.zend.com/manual/en/zend.db.html#zend.db.adapter.write Example 9.14. Inserting expressions to a table <?php $data = array( 'created_on' => new Zend_Db_Expr('CURDATE()'), 'bug_description' => 'Something wrong', 'bug_status' => 'NEW' ); $db->insert('bugs', $data); Hope this helps! Best regards, Darby Tony Harrison wrote: > Hello, how do I insert the current time into a mysql datetime field, > using the insert() method? Normally I would use the MySQL now function, > but I can't work out how to pass a MySQL function as a field value. > > Thanks, > Tony. >
