Login Page - Create Account

Support Board


Date/Time: Fri, 27 Sep 2024 07:22:58 +0000



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

[2021-08-09 20:36:39]
Sawtooth - Posts: 4092
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