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
I probably should have explicitly stated that my suggestion only worked
up to 24 hours. Unfortunately I couldn't think of a solution for greater
values.
Yesterday Igor posted a solution that works with days. You never
responded to him so perhaps you didn't see it. I'll copy it here:
**
SELECT
On Mon, Nov 2, 2009 at 1:08 PM, DaleEMoore wrote:
>
> Thanks David SELECT STRFTIME('%H:%M:%f',62.5,'unixepoch') works great for
> seconds less than 1 day!
>
> I wonder what I should do where the time becomes days, weeks, months, years?
I have no idea why you think it won't work for long time per
Thanks David SELECT STRFTIME('%H:%M:%f',62.5,'unixepoch') works great for
seconds less than 1 day!
I wonder what I should do where the time becomes days, weeks, months, years?
Do you have any suggestions about how to handle:
SELECT STRFTIME('%y-%m-%d.%H:%M:%f',962.5,'unixepoch')
I look forward
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
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)) + '.' +
>> STRF
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))
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--tp26154270p26155
On Sun, 2009-11-01 at 12:15 -0800, 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)) + '.'
Hi Alex;
SUM(STRFTIME('%s', tripSeconds)) gives me -210748564714, what did you get?
I look forward to 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--tp26154270p26154644.html
Sen
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)
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(tr
12 matches
Mail list logo
