Hi All; I want to enter my trip times. I would like to enter something like 5:6:7.89 for 5 hours, 6 minutes, 7 seconds and 89 hundredths. Some time later I would like to sum all these times and have it represented as years-months-days.hours:minutes:seconds.hundredths.
How would you approach this problem with sqlite? I have mocked up something that enters like 5:6:7.89 then converts that to seconds as a Double data type. Now I'm having problems getting the proper formatting out. I would be happy to have any ideas you care to share, Dale E. Moore _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
