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

How to Convert milliseconds to dd:mm:yyyy hh:mm:ss?

32 次查看（过去 30 天）
Megha
Megha 2018-5-23
回答： Megha 2018-5-23
I have rows that contains 'gregorian' Date and time for each observation in milliseconds since 1970-01-01 00:00:00.0 UTC.
How can I convert this millisecond into dd:mm:yyyy hh:mm:ss?

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

采纳的回答

Andrei Bobrov
Andrei Bobrov 2018-5-23
T = datetime(1970,1,1,0,0,0,0,'TimeZone','UTC','F','uuuu-MM-dd''T''HH:mm:ss.SSS Z');
addMS = milliseconds(cumsum([0;randi(2e8,10,1)]));
out = T + addMS;

更多回答（2 个）

Megha
Megha 2018-5-23
Well, I also got the solution from other google search results,
date = datestr(t/86400000 + datenum(1970,1,1));
Thank you @ Walter Roberson and @ Andrei Bobrov for spending your time on this.
Walter Roberson
Walter Roberson 2018-5-23
You might be able to use datetime() with 'convertfrom', 'posixtime'
Or see https://www.mathworks.com/matlabcentral/answers/6117-convert-date-to-unix-time#answer_8508 for the opposite way, which you could then invert.
  3 个评论
显示 1更早的评论
Walter Roberson
Walter Roberson 2018-5-23
>> datetime(1504224000,'convertfrom','posixtime')
ans =
01-Sep-2017 00:00:00
Megha
Megha 2018-5-23
@walter this is the same o/p that i fed to my i/p!
while running
int32(floor(86400 * (datenum('01-Sep-2017') - datenum('01-Jan-1970'))))
as given under the link in your answers!!

请先登录，再进行评论。

类别

在 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