Change Date Formatting for Excel in Matlab

3 次查看(过去 30 天)
Hi community,
I am working on script to read from file and save to Excel, currently have dates in form of '10/12/2024; 10:58:49'.
I want to use the datestr function to get it in a readable way like '10-Dec-2024 10:58:49'
Can someone help me in this ? I am using MATLAB R2024a
Thanks

采纳的回答

Pratyush Swain
Pratyush Swain 2025-1-3
编辑:Pratyush Swain 2025-1-3
Hi Devidutta,
The 'datestr' function is not recommended to be used since R2022b as mentioned here: https://www.mathworks.com/help/matlab/ref/datetime.datestr.html
Alternatively you can use this following approach to acheive your desired date & time format:
% Original date string, separated by semicolon
dateStr = '10/12/2024; 10:58:49';
% Convert to datetime
dt = datetime(dateStr, 'InputFormat', 'dd/MM/yyyy; HH:mm:ss');
% Format the date using the datetime display format
dt.Format = 'dd-MMM-yyyy HH:mm:ss';
% Display the result
disp(char(dt));
10-Dec-2024 10:58:49
For more information on 'datetime' function, please refer to https://www.mathworks.com/help/matlab/ref/datetime.html
Hope this helps.

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

产品


版本

R2024a

Community Treasure Hunt

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

Start Hunting!

Translated by