SELECT SUM(STRFTIME('%s', 62.4)) gets -210861368640 and I would like
0.0:01:02.4 or the appropriate days.hours:minutes:seconds.hundredths.
--
View this message in context:
http://old.nabble.com/SUM%28tripSeconds%29-and-format-output-as-days.hours%3Aminutes%3Aseconds.hundredths--tp26154270p26155824.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