RE: [oic] TIME function in ODF vs OOXML

["Andreas J. Guelzow" <andreas.guelzow@concordia.ab.ca>]

On Tue, 2012-05-22 at 16:21 -0600, Dennis E. Hamilton wrote:
> Here are some important distinctions that were lost at some point:
> 
>    Time is a subtype of number, where a time value of 1 = 1 day = 
>    24 hours. Note that the time inside one day is a fraction between 
>    0 and 1, so typical implementations will only be able to compute 
>    approximations of the correct time value.
> 
>    Implementations may first perform INT() on the hour, minute, and 
>    second before doing the calculation. Therefore, only integer
> values 
>    are portable between implementations. Hours, minutes, and seconds 
>    may be arbitrary numbers (they must not be limited to the ranges 
>    0..24, 0..59, or 0..60 respectively).
> 
>    Note that in typical implementations, a value displayed as time 
>    has its integer portion discarded and then time is computed; for 
>    computational purposes, though, the entire value is retained.
> 
> It would be interesting to know when this changed, and why.

Note that the second item (INT...) is still in ODF 1.2:
------------------------------------------------------------------------
Constraints: None. Evaluators may first perform INT() on the hour,
minute, and second before doing the calculation.

Hours, minutes, and seconds may be any number (they shall not be limited
to the ranges 0..24, 0..59, or 0..60 respectively).
------------------------------------------------------------------------

Andreas

-- 
Andreas J. Guelzow, PhD, FTICA
Concordia University College of Alberta

Attachment: signature.asc
Description: This is a digitally signed message part