How to Compare datetimes with milisecs?
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Réponse acceptée
Steven Lord
le 7 Fév 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 commentaire
Plus de réponses (2)
Are Mjaavatten
le 7 Fév 2018
s = 30; % The accuracy you desire (in seconds)
close_enough = abs(u1200lab(1,1)-u1300processo(1,1)) < 1/24/3600*s
Peter Perkins
le 7 Fév 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 commentaires
Walter Roberson
le 8 Fév 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.
Voir également
Catégories
En savoir plus sur Tables dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!