Subject | Re: [firebird-support] Strange timestamp math w/ FB 2.5 |
---|---|

Author | Kjell Rilbe |

Post date | 2010-10-22T06:28:16Z |

Paul Vinkenoog skriver:

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]

> The subtraction result is precise enough, but Rick stores it in aOh, I missed that. Thank you for clarifying.

> 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).

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]