Re: [firebird-support] DATEDIFF(HOUR...) returns 1 for a 45 minutes interval

Re: [firebird-support] DATEDIFF(HOUR...) returns 1 for a 45 minutes interval

[firebird-support] DATEDIFF(HOUR...) returns 1 for a 45 minutes interval

Hi all 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 tStartTime and tEndTime field values 26.08.2014, 08:38:00.00026.08.2014, 09:45:00.000

Re: [firebird-support] DATEDIFF(HOUR...) returns 1 for a 45 minutes interval

On 4-10-2014 14:11, venussof...@gmail.com [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

Re: [firebird-support] DATEDIFF(HOUR...) returns 1 for a 45 minutes interval

Hi all 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 tStartTime and tEndTime field values 26.08.2014, 08:38:00.00026.08.2014, 09:45:00.000 26.08.2014,