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]