I'd like to SUM(tripSeconds) and format output as
days.hours:minutes:seconds.hundredths, but have not been able to figure out
how to do that with sqlite. This didn't seem to come close:
SELECT
STRFTIME('%d', SUM(tripSeconds)) + '.' +
STRFTIME('%H', SUM(tripSeconds)) + ':' +
STRFTIME('%M', SUM(tripSeconds)) + ':' +
STRFTIME('%f', SUM(tripSeconds)) AS Duration,
SUM(tripSeconds)
Any ideas are appreciated,
Dale E. Moore
--
View this message in context:
http://old.nabble.com/SUM%28tripSeconds%29-and-format-output-as-days.hours%3Aminutes%3Aseconds.hundredths--tp26154270p26154270.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
