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]
