清空筛选条件
清空筛选条件

datestr problem with minutes

3 次查看（过去 30 天）
Vanessa
Vanessa 2017-6-29
评论： Andrei Bobrov 2017-6-29
Hello everyone,
I'm encountering a problem with date conversion. I have a dataset column with dates in '1/5/2017 12:10:00AM' form and I want to convert it into '2017-05-01 00:10:00' format. I used the datestr function but the minutes are incorrect. All rows return with 00 minutes.
How can I fix this?
Thank you in advance, Vanessa
  3 个评论
显示 1更早的评论
Vanessa
Vanessa 2017-6-29
kwhm.date=datestr(kwhm.date,'yyyy-mm-dd HH:MM:SS');
date '1/5/2017 12:10:00AM' '1/5/2017 12:15:00AM' '1/5/2017 12:20:00AM' etc
Andrei Bobrov
Andrei Bobrov 2017-6-29
Dear Vanessa! please accept the answers that solved your problems.

请先登录，再进行评论。

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

回答（2 个）

Walter Roberson
Walter Roberson 2017-6-29
t = datenum('1/5/2017 12:10:00AM' );
datestr(t, 'YYYY-mm-DD HH:MM:ss')
Andrei Bobrov
Andrei Bobrov 2017-6-29
编辑：Andrei Bobrov 2017-6-29
a = datetime('1/5/2017 12:10:00AM','I','dd/MM/yyyy hh:mm:ssa','F','yyyy-MM-dd HH:mm:ss')
  4 个评论
显示 2更早的评论
Vanessa
Vanessa 2017-6-29
Thank you very much!!!
Andrei Bobrov
Andrei Bobrov 2017-6-29
a = {'1/5/2017';
'1/5/2017 12:10:00AM';
'1/5/2017 12:15:00AM';
'1/5/2017 12:20:00AM';
'2/5/2017'};
t = ~cellfun(@isempty,regexp(a,'\d{4}$'));
a(t) = cellfun(@(x)[x,' 00:00:00AM'],a(t),'un',0);
out = datetime(a,'I','dd/MM/yyyy hh:mm:ssa','F','yyyy-MM-dd HH:mm:ss')

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by