MATLAB Answers

huda nawaf

convert timestamp include hours,minuts,second to real date

Asked by huda nawaf
on 30 Mar 2013


how convert this timestamp into real date?



datester, datenum do not work with it.

thanks in advance*


Does that number represent 27-Oct-2006 22:17:16 ?

approximatly it is 29-Oct-2006 23:17:16 how get that? I need that function


*can get number from this long number(1162160236000) ,then I can user datestr




No products are associated with this question.

1 Answer

Answer by Walter Roberson
on 30 Mar 2013

29th instead of 27th? Sorry I cannot explain that one. If you had said 9 days after the 27th then I could have guessed that leap years were not being taken into account, but a difference of exactly 2 days does not make any sense to me.

The conversion I did was

TS = 1162160236000;
datestr(datevec(TS/60/60/24/1000) + [1970 0 0 0 0 0])

The 1970 is in accordance with the Unix time convention of using time since the beginning of 1970.

If the difference had been 12 to 13 days, it could have represented an adjustment for the years ending in 00 not being leap years unless they were also divisible by 400. But 2 days off, I am at a loss for.

  1 Comment


can I used other way , the website of dataset give me other details about time , it give the real date , can I get integer from this information of time? I want get integer , then I can use datestr.

date_day \t date_month \t date_year \t date_hour \t date_minute \t date_second
         	29	10	2006	23	17	16

Join the 15-year community celebration.

Play games and win prizes!

Learn more
Discover MakerZone

MATLAB and Simulink resources for Arduino, LEGO, and Raspberry Pi

Learn more

Discover what MATLAB® can do for your career.

Opportunities for recent engineering grads.

Apply Today

MATLAB Academy

New to MATLAB?

Learn MATLAB today!