i've got a table wich contains two "Timestamp Fileds" with a format of hh:mm. Now i want to calculate the difference between thees fields, what i've got is
sqlite> select start, stop, round(strftime("%s", stop) - strftime("%s", start))/3600 as difference from my_tab;
stop     start      difference 
-------  --------   ----------
22:00    21:15      0.75
This is almost what i want, excelent would be a result in the hh:mm format. Can anybody give me a hint?