On 4-10-2014 14:11, venussoftop@... [firebird-support] wrote:

> I would have attached a screen shot of the sample data but I guess that
> is not possible. What I am trying to achieve right now is get the time
> difference in hh:mm format to the user

This behavior is documented at
http://www.firebirdsql.org/file/documentation/reference_manuals/reference_material/html/langrefupd25-intfunc-datediff.html

"
DATEDIFF doesn't look at any smaller units than the one specified in the
first argument. As a result,
* “datediff (year, date '1-Jan-2009', date '31-Dec-2009')” returns 0, but
* “datediff (year, date '31-Dec-2009', date '1-Jan-2010')” returns 1
"

> Please see the 4th row, the diff between 11:30 and 12:15 is 1 Hour and
> -15 mins whereas difference between 10:00 and 10:45 is 0 hour and 45 mins.

It only looks at hour fields (and higher). The difference between 11 and
12 is 1.

> Please advise on what I need to do correctly to get 0 hour and 45 mins
> for both 2nd and 4th row.

You need to diff minutes only and divide by 60 for hours. If you want
something 1 hour and 30 minutes for 90 minutes, you need to use modulus 60.

Mark
--
Mark Rotteveel