convert period (.) to colon (:) for reading time
7 views (last 30 days)
Show older comments
Hi,
I have imported some data that includes a time stamp but the way it writes it's date and time is "yyy-MM-dd HH.mm.ss"
Is there any way to convert the period (.) to a colon (:) so that matLab reads the time better?
Cheers,
Andy
1 Comment
KSSV
on 29 Jul 2020
You have many functions to read that format...you need not to change it..read about datestr, datetime, datenum, datevec.
Answers (1)
Stephen23
on 29 Jul 2020
I don't see why you need to convert any characters, MATLAB imports that format without error:
>> str = '2020-07-29 14.42.32';
>> dtm = datetime(str,'InputFormat','yyyy-MM-dd HH.mm.ss')
dtm =
29-Jul-2020 14:42:32
1 Comment
Steven Lord
on 29 Jul 2020
You can get MATLAB to show the resulting datetime in that form as well if you want.
str = '2020-07-29 14.42.32';
F = 'yyyy-MM-dd HH.mm.ss';
dtm = datetime(str, 'InputFormat', F, 'Format', F)
See Also
Categories
Find more on Dates and Time in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!