converting miliseconds to datetime value in datastore

2017 6 19
1 个回答
更新时间：2017 6 19
2 次查看（30 天）

0 个投票

Hi,
I have a set of data with the 2nd column representing the time and being in the form:
11:04:30.111234
I'm using tall arrays and datestore and was trying to use:
ds.SelectedFormats(2) = {'%{HH:mm:SS.ffffff}D'};
to set the second column as datetime value. But because of the miliseconds (.fffff) I get the errors:
Error using matlab.io.datastore.TabularTextDatastore/preview (line 39) Unable to read the DATETIME data with the format 'HH:mm:SS.ffffff'. If the data is not a time, use %q to get text data.
Can anyone help?

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

回答（1 个）

dpb
dpb 2017-6-19

0 个投票

Bad format string...use
'%{HH:mm:ss.SSSSSS}D'
instead. Cap 'S' is fractional seconds, lowercase 's' is seconds with datetime; the 'SS.fff' is datenum syntax. Confusing and hard to keep straight I know... <Format>

类别

在 帮助中心 和 File Exchange 中查找有关 Dates and Time 的更多信息

产品

标签

提问:

minomi
minomi
2017-6-19

回答：

dpb
dpb
2017-6-19

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by