how to combine a date and corresponding time column imported from a .CSV file.

for example one column has 13/11/2015 and another column has HH.mm.ss in 5 min interval for 24 hours.I want to merge this two into one format dd-mm-yy-HH-mm-ss. note: both are already in datatime type.

[Stephen23]

There are many advantages to using an ISO 8601 date format, particularly that a lexicographical sort of the strings puts the dates into the correct order. Try my FEX submissions for experimenting with ISO 8601 date strings and timestamps:

http://www.mathworks.com/matlabcentral/fileexchange/34095-date-vector-number-to-iso-8601-date-string

http://www.mathworks.com/matlabcentral/fileexchange/39389-iso-8601-date-string-to-serial-date-number

Answer 1

[Peter Perkins]

Srini, it sounds like you've imported the file OK, you just need to combine the two pieces.

Probably you used a format like '%{dd/MM/yyyy}D%{HH.mm.ss}D' t read those two columns in the file into datetime arrays (maybe in a table?). As you may have discovered, the first (call it d1) will have the time portions all set to 00:00:00, and the second (call it d2) will have the date portion all set to the current date. They may not display those parts, but they're there.

So try this:

d = d1 + timeofday(d2);
d.Format = 'dd-mm-yy-HH-mm-ss'

That's kind of a funny choice of formats, but it is legal.

Hope this helps.