i HAVE T FIELDS IN MY DATABASE,THAT

[caseye111]

i HAVE 2 FIELDS IN MY DATABASE,THAT CONTAIN TWO DIFFERENT TIMES IN THE FORM HH:MM:SS.I WANT TO CALCULATE THE DIFFERNCE BETWEEN THE TWO
SAY TIME1=01:30:00
AND TIME2=03:00:00
THEM THE TIME DIFFENECE WILL BE 01:30:00
ONCE I HAVE THIS DONE I WANT TO BE ABLE TO CONVERT IT TO MINUTES SO 01:30:00 WILL BECOME 90 MINUTES ANY IDEAS

 

[PruSQLer]

I'm not sure what time functions you have with your RDBMS but I would do this, using DB2:

select minute(time1 - time2) + (hour(time1 - time2) * 60)
from time