How to update datetime array from matlab to oracle database with multiple where clause
1 view (last 30 days)
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"
>>
0 Comments
Answers (0)
See Also
Categories
Find more on Database Toolbox 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!