how to insert date and time in database table using matlab database toolbox
7 次查看(过去 30 天)
显示 更早的评论
is it possible to insert the current time in table using the code datestr(now);? I am getting this error
Error using database/fastinsert (line 86) Input data must be a cell array, matrix, or structure
Error in licenseplate>pushbutton23_Callback (line 615) fastinsert(conn,tableName,colnames2,txt);
in the command window.
here's the code:
conn = database('vlmsystem','admin','admin');
dbpath = 'C:\Users\Sony Vaio\Documents\Task\0.1 Systems\System 1 - edited\Appendix\vlogdbase.mdb';
tableName = 'vehicleLog';
colnames = {'plate_number','date_time','login_logout'};
colnames1 = {'plate_number'};
colnames2 = {'date_time'};
colnames3 = {'login_logout'};
txt = datestr(now);
fastinsert(conn,tableName,colnames2,txt);
close(conn);
0 个评论
采纳的回答
the cyclist
2013-10-24
Does it work if you put your result in a cell array?
txt = {datestr(now)};
3 个评论
the cyclist
2013-10-25
Yes. datestr() accepts a second input argument for the format. Try
datestr(now,'yyyy-mm-dd HH:MM:SS')
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!