Subject Re: [firebird-support] Strange timestamp math w/ FB 2.5
Author Kjell Rilbe
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 Rilbe
E-post: kjell.rilbe@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64

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