How to update datetime array from matlab to oracle database with multiple where clause
Show older comments
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"
>>
Answers (0)
Categories
Find more on Other Formats in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!