How do I specify a datetime format when reading a .csv/Excel file?
3 views (last 30 days)
Show older comments
MathWorks Support Team
on 1 Apr 2020
Answered: MathWorks Support Team
on 7 Apr 2020
I would like to change the datetime format of dates read in from .csv files. How do I do that?
Accepted Answer
MathWorks Support Team
on 1 Apr 2020
You can use 'setvaropts' to change the format of datetime variables. For example:
opts = detectImportOptions('example.csv');
opts = opts.setvaropts('myVariable','InputFormat','M/d/yyyy','DateTimeFormat','dd-MMM-yyyy');
t = readtable('example.csv',opts)
% 'example.csv' contains the column:
% myVariable
% 1/31/2020
'InputFormat' tells 'readtable' how to interpret the values in the file, while 'DateTimeFormat' tells MATLAB how to display the datetimes once they are in MATLAB.
For more information, refer to the "Import Date and Time Data" section on the following documentation page:
0 Comments
More Answers (0)
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!