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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
