On 10/2/2012 1:00 PM, Bart Smissaert wrote:
Is there a way to subtract times in the text format hh:mm:ss
and return the difference in the same format?
select time(julianday('03:22:11') - julianday('01:22:33') - .5);
select time(strftime('%s', '03:22:11') - strftime('%s', '01:22:33'),
'unixepoch');
Both of these return '01:59:38'.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users