Kurt,
I managed to resolve my problem with the following. Thanks for your help.
code----------------------------------------
SELECT round((julianday(duration)-julianday('00:00:00')) * 86400) as
duration_sec
FROM call_data
WHERE julianday(call_time) <= julianday('2003-12-03 18:42')
AND (julianday('2003-12-03 18:42') - julianday(duration)) <=
julianday(call_time)
---------------------------------------------------
Lloyd
----- Original Message -----
From: "Lloyd thomas" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 28, 2004 10:28 PM
Subject: Re: [sqlite] time calculations
> I have a table that shows a list of connections showing the time the
> connection was finished and the duration.
> I wish to show concurrent connections during a particular minute.
> for instance the following would show that there was two connections
during
> 2003-12-04 09:27:00
> -----------------------------------------
> call_time | duration
> -----------------------------------------
> 2003-12-04 09:27:00 | 00:01:21
> -----------------------------------------
> 2003-12-04 09:28:00 | 00:04:19
> -----------------------------------------
>
> ----- Original Message -----
> From: "Kurt Welgehausen" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Saturday, February 28, 2004 9:26 PM
> Subject: Re: [sqlite] time calculations
>
>
> > >> it relies on having the seconds as well.
> >
> > I don't understand the question. As far as I know,
> > nothing in SQLite requires the seconds.
> >
> > sqlite> select julianday('2003-12-04 16:41');
> > julianday('2003-12-04 16:41')
> > -----------------------------
> > 2452978.19513889
> >
> > If you're getting an error msg, maybe you can be
> > more specific.
> >
> > Regards
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> >
> >
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
