convert timestamp include hours,minuts,second to real date

2 views (last 30 days)
*hi,
how convert this timestamp into real date?
ex.
1162160236000
datester, datenum do not work with it.
thanks in advance*
  6 Comments
huda nawaf
huda nawaf on 30 Mar 2013
approximatly it is 29-Oct-2006 23:17:16 how get that? I need that function
thanks
huda nawaf
huda nawaf on 30 Mar 2013
*can get number from this long number(1162160236000) ,then I can user datestr
thanks*

Sign in to comment.

Answers (1)

Walter Roberson
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
huda nawaf
huda nawaf on 31 Mar 2013
thanks,
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

Sign in to comment.

Categories

Find more on Dates and Time in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!