DATEDIFF HOUR INCORRECT ANSWER

[Gugu04]

Hello, someone has experienced something similar with the DATEDIFF function Firebird 3.0.10

Example
SELECT DATEDIFF(HOUR, TIMESTAMP '14.12.2022, 11:46:33.405', TIMESTAMP '14.12.2022, 12:00:21.710') FROM RDB$DATABASE

As a result, it shows me 1 hour when it should show 0 since it is a difference of minutes and it does not meet the fact that it is an hour.

[aafemt]

12 - 11 = 1. Your desired result is difference in minutes divided by 60. Don't use issue tracker for support questions, please.

[Gugu04]

Hi @aafemt , thanks for your reply, do you know any firebird community or channel on discord? to express doubts or suggestions

So sorry I did not mean to be unpleasant

[mrotteveel]

The main support list is https://groups.google.com/g/firebird-support, you can find more on https://firebirdsql.org/en/mailing-lists/

Also, it is always good to take a look at the documentation, for example, this behaviour is explicitly mentioned in the "Computation" section of DATEDIFF