Subject Re: [firebird-support] minutes between
Author Milan Babuskov
Svein Erling Tysvaer wrote:
> if you have two Time fields (and their definition
> is no mistake), I think I'd rather do something like
>
> CASE WHEN EndTime >= StartTime THEN (EndTime-StartTime)/60
> ELSE (EndTime-StartTime+86600)/60


Or simply ABS(EndTime-StartTime)/60

--
Milan Babuskov
http://fbexport.sourceforge.net