no en la tabla origen es varchar y la tabla destino es datetime, lo que pasa es q la tabla se llena con unos registros que estan excel, y estableci la conexion y me llena la tabla origen aqui posteo el codigo
Código PHP:
$conexion = obtenerConexion();
$row = 1;
$fp = fopen ("SISE.csv","r");
while ($data = fgetcsv ($fp, 3000, ";"))
{
$num = count ($data);
print " <br>";
$row++;
$insertar="INSERT INTO tbuzon (nu_solc,nu_solc_intr,ds_proy_evnt,fe_promt_cte,fe_promt_cte_ajus,co_cte,nb_empr,ds_t_cte,ds_uni_negc,ds_serv,instl,co_central_orig,instl_intr,ds_confg,ds_uso,ds_clas_serv,ds_red,fe_ini_oper,fe_fin_oper,durope,ds_edo_oper,t_actv,t_actor,nb_centr_trab,ds_t_actv,fe_ini,fe_fin,ds_edo_actv,nb_usr,id_actv,duract,visto_por,ds_sfase,ds_fase,ds_usr,t_lugar,nb_lugar,calle_av,casa_edf,apto_ofc,urbn,prrq,munc,nb_cdad,nb_edo,cCod_Uso) VALUES ('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]','$data[7]','$data[8]','$data[9]','$data[10]','$data[11]','$data[12]','$data[13]','$data[14]','$data[15]','$data[16]','$data[17]','$data[18]','$data[19]','$data[20]','$data[21]','$data[22]','$data[23]','$data[24]','$data[25]','$data[26]','$data[27]','$data[28]','$data[29]','$data[30]','$data[31]','$data[32]','$data[33]','$data[34]','$data[35]','$data[36]','$data[37]','$data[38]','$data[39]','$data[40]','$data[41]','$data[42]','$data[43]','$data[44]',2)";
$query=mysql_query($insertar)or die (mysql_error());
}
fclose ($fp);
$consult = "SELECT nu_solc_intr, nu_solc,nb_empr,cCod_Uso,fe_ini_oper, ds_t_actv FROM tbuzon where t_lugar=0";
$resultad = mysql_query($consult, $conexion)or die (mysql_error());
while($row= mysql_fetch_array($resultad)) {
$config='1';
$nu_sol= $row['nu_solc_intr'];
$nu_solc1= $row['nu_solc'];
$nb_emp= $row['nb_empr'];
$cCod_Us= $row['cCod_Uso'];
$ds_t_act= $row['ds_t_actv'];
$fe_ini_ope= $row['fe_ini_oper'];
$f_fin=$actual;
$status='0';
$cond='1';
$null='NULL';
$fecha=date("Y-m-d H:i", strtotime($fe_ini_ope));
$sql11="insert into tconfigurador VALUES('$config','$nu_sol','$nu_solc1','$nb_emp','$cCod_Us','$ds_t_act','$fecha','$f_fin','$status','$cond','$null','$null','$null')";
$row= mysql_query($sql11, $conexion)or die (mysql_error());
echo $sql11;
}