Hello, I'm having a problem with an update statement. The Zend_Date object is convert to string like this: "30 jul 2007 19:05:08". Mysql returns an error that the datetimeformat is not correct. This is true, because it supposed to be "2007-07-30 19:05:08". How can I take care that the Zend_Db converts my Zend_Date correct?

I tried a lot. I now have this:

date_default_timezone_set('Europe/Amsterdam');

Zend_Locale_Format::setOptions(array('locale' => 'nl_NL', 'format_type' => 'iso', 'fix_date' => false, 'date_format' => Zend_Date::ISO_8601 ) );


$objDate = new Zend_Date( Zend_Date::now(), Zend_Date::ISO_8601 );
$set = array ( 'EndDateTime' => $objDate );
$where = $db->quoteInto("Id = '?'", $objImportRun->GetId() );
$rows_affected = $db->update('ImportRuns',$set, $where);

try this:

__________________
http://polygon-studio.com/