Cell Dates to Timestamp conversion

10 visualizaciones (últimos 30 días)
Emmanouil Barmpounakis
Emmanouil Barmpounakis el 24 de Jun. de 2015
Comentada: Emmanouil Barmpounakis el 24 de Jun. de 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).

Respuesta aceptada

Peter Perkins
Peter Perkins el 24 de Jun. de 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 comentario
Emmanouil Barmpounakis
Emmanouil Barmpounakis el 24 de Jun. de 2015
Thank you for your reply. It works perfectly .

Iniciar sesión para comentar.

Más respuestas (0)

Categorías

Más información sobre Dates and Time en Help Center y File Exchange.

Productos

Community Treasure Hunt

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

Start Hunting!

Translated by