Alex Mandel wrote:
> DaleEMoore wrote:
>> I'd like to SUM(tripSeconds) and format output as
>> days.hours:minutes:seconds.hundredths, but have not been able to figure out
>> how to do that with sqlite. This didn't seem to come close:
>>
>> SELECT
>> STRFTIME('%d', SUM(tripSeconds)) + '.' +
>> STRFTIME('%H', SUM(tripSeconds)) + ':' +
>> STRFTIME('%M', SUM(tripSeconds)) + ':' +
>> STRFTIME('%f', SUM(tripSeconds)) AS Duration,
>> SUM(tripSeconds)
>>
>> Any ideas are appreciated,
>> Dale E. Moore
I assume this involves multiple lookups to get the time. It could so happen
they
are a different second, hour, day or even year. That looks dangerous to me.
> What about something like
> SELECT SUM(STRFTIME('%s', tripSeconds)) AS Duration
> from table
> GROUP BY trip
>
> Alex
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
