RE: MS-FO-LC1-055: Section 9.3 comparison on date and time

> We believe the example is wrong.
> 
> Functions and Operators, Section 9.3.14.1 Examples
> The third bullet, the result should be "false", not "true".
> 
> 28:00:00Z is not less than 02:00:00Z; even if adjusted by 24 
> hours, 04:00:00Z is still not less than 02:00:00Z
> 
> (ORA-FO-DATETIME-EXAMPLES)
> 
> 
I'm increasingly of the view that we should not support ordering or
differencing of time values. It's meaningless except in the context of a
date. The user should be obliged to turn the time into a dateTime before
doing such operations.

Michael Kay

Received on Tuesday, 1 July 2003 13:51:04 UTC