How to update datetime array from matlab to oracle database with multiple where clause
Mostrar comentarios más antiguos
i have an 3-d datetime array and want to update the same in ORCALE table.
arr1=[19-Apr-2019 06:00:00 , 19-Apr-2019 00:00:00 , 19-Apr-2019 00:00:0, 19-Apr-2019 00:00:00 19-Apr-2019 00:00:00 19-Apr-2019 00:00:00 19-Apr-2019 00:00:00 19-Apr-2019 00:00:00 19-Apr-2019 00:00:00]
arr2=array2table(arr1, 'VariableNames',{'HORIZ','DY1EN','DY1EX','DY2EN','DY2EX','DY3EN','DY3EX','SH1EN','SH1EX'.....
'SH2EN'});
where=['where HORIZ=' datestr(arr1) 'AND EQUIP_ID=' num2str(q)];
col={'HORIZ','DY1EN','DY1EX','DY2EN','DY2EX','DY3EN','DY3EX','SH1EN','SH1EX'.....
'SH2EN'};
update(conn,'SM',col,arr2,where);
i am getting error as "Input structure must contain fields of type double or cell"
>>
Respuestas (0)
Categorías
Más información sobre Other Formats en Centro de ayuda y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!