Paul Vinkenoog skriver:

> The subtraction result is precise enough, but Rick stores it in a
> decimal(18,4), so the precision becomes 8,64 sec (1/10000 of a day).
>
> Multiplication by 86400 before storing the result in the var gives
> millisecond precision (the fourth digit after the decimal point is
> meaningless: 'NOW' has milliseconds precision).

Oh, I missed that. Thank you for clarifying.

Kjell
--
------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell.rilbe@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64


[Non-text portions of this message have been removed]