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

Author | Kjell Rilbe |

Post date | 2010-10-21T03:23:16Z |

Helen Borrie skriver:

Kjell

--

--------------------------------------

Kjell Rilbe

DataDIA AB

E-post: kjell@...

Telefon: 08-761 06 55

Mobil: 0733-44 24 64

> The difference between two timestamps returns a result in days. 0.0002Oh. But does datediff provide better precision?

> of a day is 17.28 seconds....but the interval calculation corrects to 4

> places of decimal. So, for example, if the elapsed time was actually

> 16.703 seconds, the corrected result in days would be still be 0.0002.

Kjell

--

--------------------------------------

Kjell Rilbe

DataDIA AB

E-post: kjell@...

Telefon: 08-761 06 55

Mobil: 0733-44 24 64