Hi David;
That's LOVELY for small numbers like:
SELECT STRFTIME('%H:%M:%f',62.5,'unixepoch')
00:01:02.500
What do you think I should do with larger periods of time? In the following
I hoped for 00-00-00.01:02.500.
SELECT STRFTIME('%Y-%m-%d.%H:%M:%f',62.5,'unixepoch')
1970-01-01.00:01:02.500
I really appreciate hearing from you,
Dale
--
View this message in context:
http://old.nabble.com/SUM%28tripSeconds%29-and-format-output-as-days.hours%3Aminutes%3Aseconds.hundredths--tp26154270p26156678.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
