Re: [sqlite] time functions - expanding

2004-02-25 Thread Jake Skinner
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)) -

Re: [sqlite] time functions - expanding

2004-02-25 Thread D. Richard Hipp
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)) - (strftime("%H",start_tim

Re: [sqlite] time functions - expanding

2004-02-25 Thread D. Richard Hipp
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)) - (strftime("%H",start_time)*60+strftime("%M",star

[sqlite] time functions - expanding

2004-02-25 Thread 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