How to update datetime array from matlab to oracle database with multiple where clause
Afficher commentaires plus anciens
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"
>>
Réponses (0)
Catégories
En savoir plus sur Other Formats dans Centre d'aide et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!