Cell Dates to Timestamp conversion

Question

Emmanouil Barmpounakis 2015-6-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/225098-cell-dates-to-timestamp-conversion

评论： Emmanouil Barmpounakis 2015-6-24

I have a 3480x2 cell. The first column shows the date (6/24/2015) and the second one shows the hour (8:33:49). How can I create a new array where the first column will appear as a UNIX timestamp?

For example, C(1,1)=1435134829 (which is equal to 6/24/2015 - 8:33:49).

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Peter Perkins 2015-6-24

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/225098-cell-dates-to-timestamp-conversion#answer_183896

在 MATLAB Online 中打开

In MATLAB R2014b or later, using datetime:

>> c = {'6/24/2015' '8:33:49'; '6/24/2015' '8:33:48'}
c = 
    '6/24/2015'    '8:33:49'
    '6/24/2015'    '8:33:48'
>> d = datetime(strcat(c(:,1),{' '},c(:,2)))
d = 
   24-Jun-2015 08:33:49
   24-Jun-2015 08:33:48
>> format long g
>> posixtime(d)
ans =
                1435134829
                1435134828