convert timestamp include hours,minuts,second to real date

*hi,

how convert this timestamp into real date?

ex.

    1162160236000

datester, datenum do not work with it.

thanks in advance*

[per isakson]

Why do you believe this is a timestamp?

[Walter Roberson]

Is that a string or an integer? How does the number break down into hours, minutes, and seconds?

[huda nawaf]

*I got this data from http://www.grouplens.org/node/462, it is about rating of movies.

Example:
    userID  movieID  rating  timestamp
        75  3  1  1162160236000
thanks*

[Walter Roberson]

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

[huda nawaf]

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

thanks

[huda nawaf]

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

thanks*

Answer 1

[Walter Roberson]

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.

[huda nawaf]

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