D. Richard Hipp wrote:
D. Richard Hipp wrote:
Jake Skinner wrote:
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)) -
D. Richard Hipp wrote:
Jake Skinner wrote:
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)) -
Jake Skinner wrote:
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)) -
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
4 matches
Mail list logo