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).

 Akzeptierte Antwort

Peter Perkins
Peter Perkins am 24 Jun. 2015

0 Stimmen

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
Hope this helps.

Weitere Antworten (0)

Kategorien

Produkte

Community Treasure Hunt

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

Start Hunting!

Translated by