DateTime YYYYMMDD HHMMSS ConvertTo

Hi everyone,

i have a question:

i have a .txt file with two collums, which are the date and the time in this format: YYYYMMDD HHMMSS

now i want to convert it to this format DD-MM-YYYY HH:MM:SS

I already managed to convert the date but not the time:

date = datetime(File.txt,'ConvertFrom','yyyymmmdd')

output:

03-Feb-2021 00:00:00

thanks for your help!!

Answer 1

[Ayush]

Hi,

To convert the data into the required format, you can make use of the "Format" property of the "datetime" object and set it to the desired output format. Refer to the example code below for a better understanding:

% Example date and time in the format YYYYMMDD HHMMSS
originalDateTime = '20231005 123456';

% Convert the string to a datetime object with the specified input format
dt = datetime(originalDateTime, 'InputFormat', 'yyyyMMdd HHmmss');

% Set the desired output format
dt.Format = 'dd-MM-yyyy HH:mm:ss';

% Convert the datetime object to a string
formattedDateTime = char(dt);

% Display the result
disp(formattedDateTime);

05-10-2023 12:34:56

For more information on the "datetime" function, refer to the below documentation:

https://www.mathworks.com/help/matlab/ref/datetime.html