How to Compare datetimes with milisecs?
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Tiago Dias
am 6 Feb. 2018
Bearbeitet: Tiago Dias
am 8 Feb. 2018
Hi, when i compare the i-value from each table it says they are not the same becauase one has milisecs and the other has not, how to delete the mili secs so when i do
u1200lab(1,1)==u1300processo(1,1)
it gives me a positive logical answer?
Because now it says it is not true
0 Kommentare
Akzeptierte Antwort
Steven Lord
am 7 Feb. 2018
Let's generate two sample datetime objects and set their Format to show just the times with fractional seconds.
N = datetime('now');
N.Format = 'hh:mm:ss.SSS'
X = N + seconds(10*randn);
X.Format = 'hh:mm:ss.SSS'
What's the difference between the two? Is it less than 5 seconds?
d = abs(X-N);
d.Format = 'mm:ss.SSS'
d < seconds(5)
Or you can convert the difference into a number of seconds and compare with the number 5.
sec = seconds(d)
sec < 5
If you want to round the datetime object you could use dateshift to shift to the 'start' or 'end' of the second or shift to the 'nearest' second.
dateshift(N, 'start', 'second')
dateshift(N, 'start', 'second', 'nearest')
dateshift(N, 'end', 'second')
1 Kommentar
Weitere Antworten (2)
Are Mjaavatten
am 7 Feb. 2018
s = 30; % The accuracy you desire (in seconds)
close_enough = abs(u1200lab(1,1)-u1300processo(1,1)) < 1/24/3600*s
Peter Perkins
am 7 Feb. 2018
This has nothing to do with milliseconds, at least not if what you posted is what you are actually doing.
I don't know what you are seeing, but the two mat files you've attached each contain an 8x1 table, each of whose sole variable is an 8x1 datetime. These tables may be a step along a longer journey, but in general, there's no point in creating a table with one variable.
In any case, what I see is
>> u1200lab(1,1)==u1300processo(1,1)
Undefined operator '==' for input arguments of type 'table'.
and that's because you are wanting to compare the datetime values in the table but in fact you are trying to compare two 1x1 tables and there's no comparison operator for tables because they are containers. What you need to do is compare the datetime values. Here's one way:
>> u1200lab.DataColheita(1) == u1300processo.Data(1)
ans =
logical
1
3 Kommentare
Walter Roberson
am 8 Feb. 2018
In u1200lab.DataColheita(1) the .DataColheita tells it which column of the table to look in. The (1) is then the row number of that column.
Siehe auch
Kategorien
Mehr zu Tables finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!