Re: [sqlite] How do you save time in a sqlite database?

Dear P; Thanks so much for your knowledge and for sharing with me; I very much appreciate it! I'm doing a little ASP.NET application in MONO, Dale On Mon, Nov 2, 2009 at 4:05 PM, P Kishor wrote: > On Mon, Nov 2, 2009 at 3:30 PM, Dale E. Moore > wrote: > > Hi Puneet; > &

Re: [sqlite] SUM(tripSeconds) and format output as days.hours:minutes:seconds.hundredths?

I've been fiddling through Nabble, and I've been missing things. (Perhaps it's me and not Nabble;( You guys are WONDERFUL! David, Igor, Alex; all have given me vital information and I very much appreciate it! Thanks!! Dale On Mon, Nov 2, 2009 at 4:24 PM, David Bicking wrote: > I probably shou

Re: [sqlite] How do you save time in a sqlite database?

Hi Puneet; Thanks for your feedback! My complete picture is that I would I'd like to enter running, cycling, walking times like hh:mm:ss.hundredths and have them saved magically as DURATION in sqlite. Then I would like to run a SELECT SUM(DURATION) ... GROUP BY something-or-other and have yy:mont

[sqlite] How do you save time in a sqlite database?

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.