Subject Re: [firebird-support] difference in minutes
Author Helen Borrie
At 08:06 AM 28/11/2005 +0000, you wrote:
>Hi folks,
>I have two TIME fields in my table.
>How do i calculate an integer number which represents
>difference in minutes of these two values?

TIME type - TIME type = seconds; so just divide the result by 60. This
isn't like the timer on your microwave, so you might also want to do a bit
more arithmetic to convert the decimal part to seconds, e.g. a result of
10.5000 is 10 mins + 30 seconds, not 10 mins + 50 seconds....