Cell Dates to Timestamp conversion

12 Ansichten (letzte 30 Tage)
Emmanouil Barmpounakis
Emmanouil Barmpounakis am 24 Jun. 2015
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
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.
  1 Kommentar
Emmanouil Barmpounakis
Emmanouil Barmpounakis am 24 Jun. 2015
Thank you for your reply. It works perfectly .

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Kategorien

Mehr zu Dates and Time finden Sie in Help Center und File Exchange

Produkte

Community Treasure Hunt

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

Start Hunting!

Translated by