Determine whether a column in a Table contains time data

How can I determine whether a column in a Table is a time vector? In addition, how can I ensure that all rows in this column have the same time series format?

Answer 1

[Iddo Weiner]

Please define "time vector" - do you mean that the numbers should simply be monotonically increasing? or do you also have a certain "time format" / "time pattern" you're looking for ? If it's the first option, the solution is simple enough:

function out = is_monotonically_increasing(vector)
if sum (vector(2:end) - vector(1:end-1) <= 0) > 0
    Out = 0;
else
    Out = 1;
end
end

If you need something more specific please describe more thoroughly

[Walter Roberson]

That test could be optimized to

Out = all(diff(vector) > 0);

[Walter Roberson]

Or using built-in functions:

Out = issorted(vector);

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

[Iddo Weiner]

Absolutely! Aniruddha - are you there? does this help? Or do you have different specifications?