W3C home > Mailing lists > Public > public-qt-comments@w3.org > July 2003

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

From: Kay, Michael <Michael.Kay@softwareag.com>
Date: Tue, 1 Jul 2003 19:50:45 +0200
Message-ID: <DFF2AC9E3583D511A21F0008C7E62106073DCF96@daemsg02.software-ag.de>
To: Stephen Buxton <stephen.buxton@oracle.com>, public-qt-comments@w3.org

> 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

This archive was generated by hypermail 2.4.0 : Friday, 17 January 2020 16:56:48 UTC