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

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?

Answer 1

[Andrei Bobrov]

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;

[Megha]

@ Andrei Bobrov: yes thank you

it worked for me

Answer 2

[Megha]

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.

Answer 3

[Walter Roberson]

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.

[Megha]

@Walter: ok. thank you. I got this value 1504224000.

Now how to convert this value to dd:mm:yyyy hh:mm:ss?

[Walter Roberson]

>> datetime(1504224000,'convertfrom','posixtime')
ans = 
   01-Sep-2017 00:00:00

[Megha]

@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!!