We should clarify in the spec that the <, >, <=, and >= operators are not defined for LocalTime.
Why not? Well, because:
- Time of day doesn't have a meaningful total order. Times form a topological circle. It's not meaningful to say that 23:59:59 > 00:00:00. That's just completely arbitrary. Is the first time a day after or one second before the second time? You need a date to know for sure.
- Oracle has no ANSI-like
TIME type, and to emulate it requires jumping through really disgusting hoops.
We should clarify in the spec that the
<,>,<=, and>=operators are not defined forLocalTime.Why not? Well, because:
TIMEtype, and to emulate it requires jumping through really disgusting hoops.