This query is running on MySql Workbench now I need this in Zend.
INSERT new_table SELECT * from old_table WHERE date(created_time) < 2015-04-05;
All you need to do is just use the query
method of your adapter.
// $db is your DB adapter, e.g. an instance of Zend_Db_Adapter_Mysqli
$db->query('INSERT new_table SELECT * from old_table WHERE date(created_time) < 2015-04-05');