Re: [SQL] select values from interval

2005-07-04 Thread Bruno Wolff III
On Mon, Jul 04, 2005 at 14:00:57 +0200, Josep SanmartĂ­ <[EMAIL PROTECTED]> wrote: > Hi, > > I've this table: am_conn(mac, user_ip, start_time, end_time). Each time > a user connects with a remote server a new row is added, when the user > is disconnected the end_time field is set. > > Now, I wa

[SQL] select values from interval

2005-07-04 Thread Josep SanmartĂ­
Hi, I've this table: am_conn(mac, user_ip, start_time, end_time). Each time a user connects with a remote server a new row is added, when the user is disconnected the end_time field is set. Now, I want to know if there is a way (sql statement) to know how many connections are up during an interva