Login Page - Create Account

Support Board


Date/Time: Sat, 23 Nov 2024 16:05:39 +0000



Post From: When comparing a FRACTIME to a TIMEVALUE, the >= operator ignores the =

[2021-08-09 20:36:39]
Sawtooth - Posts: 4118
More generally, only the equal (=) and not-equal (<>) operators have this extra provision to handle numbers that are slightly off. All of the other operators (<, <=, >=, >) are strict in their comparisons. This could potentially be changed if the minor impacts to performance and accuracy are considered worth it.
Dealing with floating point imprecision is a continual problem, so this change would be welcomed.
Date Time Of Last Edit: 2021-08-09 20:38:13