Subject Re: [firebird-support] minutes between
Author Helen Borrie
>d_dude_2003 wrote:
> > I have two TIME variables in FireBird stored proc. How do i calculate
> > the integer representing the minutes difference between them?
> >
> > Is it (TIME2 - TIME1)/60?

YES


At 09:43 PM 5/07/2007, Magnus Titho wrote:

>(Time2 - Time1) * 24 * 60

Not so for (TIME - TIME): it is a DECIMAL (9,4) in seconds.

./hb