How to convert a string data time to a number
17 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Not sure if i am going about this the right way but here goes...
Originally trying to plot data from a table until I realized the data string format is incorrect i.e '10/08/2018 6:30:32 PM' Im assuming the function wont plot the character array hence I would need to convert the string to number format.
I extracted the column from a table and converted into a cell array...
if true
% Datestring = {converttime};
end
if true
% formatIn = '';
end
if true
% datenum(DateString,formatIn);
end
Im unsure what to put in the variable formatIn? Are you telling matlab to convert using a predefined number dateformat?
Appreciate some help with this.
0 comentarios
Respuestas (4)
madhan ravi
el 31 de Oct. de 2018
dt = datestr(now,'mmmm dd, yyyy HH:MM:SS.FFF AM') %an example
1 comentario
madhan ravi
el 31 de Oct. de 2018
Star Strider
el 31 de Oct. de 2018
Try this:
dn = datenum('10/08/2018 6:30:32 PM', 'dd/mm/yyyy HH:MM:SS AM')
q = datestr(dn) % Check Conversion
1 comentario
Star Strider
el 31 de Oct. de 2018
The documentation is absolutely opaque on using scatter with table objects. I have a timetable, table and cell arrays (that I created from the same original timetable with information from another Question), and the only way I could get it to work was to use the cell array, and then concatenate it to a numeric array.
Here, the cell array is called ‘TT_C’, the first 2 columns are datetime objects, and the rest are numeric:
figure
scatter([TT_C{:,1}], [TT_C{:,9}])
grid
Perhaps others can get it to work with table objects. It eludes me.
Peter Perkins
el 31 de Oct. de 2018
Don't use datenums. Convert your text to datetime:
>> datetime('10/08/2018 6:30:32 PM','InputFormat','MM/dd/yyyy hh:mm:ss a')
ans =
datetime
08-Oct-2018 18:30:32
and then just plot (at least in recent versions of MATLAB).
0 comentarios
Dan Howard
el 31 de Oct. de 2018
1 comentario
Peter Perkins
el 1 de Nov. de 2018
If the variable in your table is a datetime, then no, at least in recent versions. I can't recall when scatter began datetime support. In any case, the plot function has since R2014b, and you can make a scatter plot with that.
Ver también
Categorías
Más información sobre Logical en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!