[sqlite] time functions - expanding

[Jake Skinner]

What has been done with date and time functions is great.

I would like to suggest a further extension to these functions, at the 
moment (I'm really only talking about the time functions however it 
could also apply to the date functions as well) it is possible to select 
either the hour or minute portion of the time via %H or %M, I would like 
to be able to format the total time in minutes. ie 04:00 is 240 minutes, 
for the purposes of summing.

I am unsure whether this is possible due to the typeless nature of 
sqlite - which is a much bigger boon than some tiny obscure time\date 
functions.

Could anyone suggest other ways of achieving summing of times ie 
sum(end_time - start_time). At the moment I have a rather unwieldy sql 
query (see below).

sum(
    (strftime("%H",end_time)*60+strftime("%M",end_time))  
    -
    (strftime("%H",start_time)*60+strftime("%M",starttime)) 
)

cheers
Jake
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]