MATLAB can't read time column in database (querybuilder and dexplore)

Question

J 2015-7-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/231189-matlab-can-t-read-time-column-in-database-querybuilder-and-dexplore

评论： Justin Koch 2020-9-11

Hi,

I'm trying to import some data from a database using dexplore. When I navigate through the GUI, the time field is blank, almost like MATLAB can't read the data. I know there is data there because I can see all the timestamps in SQL Server Management Studio. Please see the attached screen shots.

How can I fix this?

First image is the time column's properties in SQL Server Management Studio Second image is the view in Management Studio. Third image is the view in dexplorer in matlab.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

J 2015-7-26

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/231189-matlab-can-t-read-time-column-in-database-querybuilder-and-dexplore#answer_187226

Bump. Can anyone help with this?

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Justin Koch 2020-9-11

I'm assuming you're not still trying to figure this out 5 years later, but for anyone who stumbles across this thread like I did: the trick is to convert your time field to a character one prior to attempting import into MATLAB.

e.g. in SQL convert the column storing times to NVARCHAR

CONVERT(NVARCHAR, TimeColumn) as 'Time'

请先登录，再进行评论。