exec & fetch commands (Problem with data format?)

2 次查看（过去 30 天）

J 2015-8-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/232908-exec-fetch-commands-problem-with-data-format

Hi, I'm having some problems importing a time variable from my database into MATLAB. I think the problem might have something to do with the format of the time parameter which is:

HH:MM:SS.MS

Example:

00:04:13.46

H = Hour, M = Minute, S = Second, MS = Millisecond.

When I use dexplore or querybuilder MATLAB doesn't seem to process the fact there is a time field here, instead just returning a [ ]. I think this may be something to do with the format of the time field.

My current code looks like this:

%Set preferences with setdbprefs.
setdbprefs('DataReturnFormat', 'structure');
setdbprefs('NullNumberRead', 'NaN');
setdbprefs('NullStringRead', 'null');
%Make connection to database.  Note that the password has been omitted.
%Using ODBC driver.
conn = database('DATABASE', '', '');
%Read data from database.
curs = exec(conn, ['SELECT   ARDAT.Date'...
    ' ,  ARDAT.Time'...
    ' FROM   DATABASE.dbo.ARDAT ']);
curs = fetch(curs);
close(curs);
%Assign data to output variable
data = curs.Data;
%Close database connection.
close(conn);
%Clear variables
clear curs conn