how to insert date and time in database table using matlab database toolbox

14 次查看（过去 30 天）
Lloyd
Lloyd 2013-10-24
评论： the cyclist 2013-10-25
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);

请先登录，再回答此问题。

采纳的回答

the cyclist
the cyclist 2013-10-24
Does it work if you put your result in a cell array?
txt = {datestr(now)};
  3 个评论
显示 1更早的评论
Lloyd
Lloyd 2013-10-24
is there a way to change the format of the date and time? I think the current format is dd-mm-yyy 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!

Translated by