Thanks David SELECT STRFTIME('%H:%M:%f',62.5,'unixepoch') works great for seconds less than 1 day!
I wonder what I should do where the time becomes days, weeks, months, years? Do you have any suggestions about how to handle: SELECT STRFTIME('%y-%m-%d.%H:%M:%f',962.5,'unixepoch') I look forward to hearing from you, Dale E. Moore -- View this message in context: http://old.nabble.com/SUM%28tripSeconds%29-and-format-output-as-days.hours%3Aminutes%3Aseconds.hundredths--tp26154270p26157787.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users