List:General Discussion« Previous MessageNext Message »
From:Peter J Milanese Date:September 3 2004 12:21pm
Subject:RE: HELP ME WITH THIS
View as plain text  
If it were all in one row, you may be able to compare datetime fields. 

I do not know if you can do this with 2 rows, and the query will probably
be rough. 

Did you design the table? Can you create it so that your row has start and
stop times, instead of creating another row?



> -----Original Message-----
> From: Karma Dorji [mailto:k_dorji@stripped]
> Sent: Friday, September 03, 2004 5:06 AM
> To: mysql@stripped
> Subject: HELP ME WITH THIS
> 
> Hello can anyone help me with this,
> 
> i have a table, like the one below,
> i need to find the time difference between the Start and Stop from a
> particular CallingStationId to particular CalledStationId.
> 
>
+------------+----------+--------------------+-------------------+--------
> --
> --------+-------------------+
> | Date       | Time     | CallingStationId   | CalledStationId   |
> AcctStatusType   | AcctSessionTime   |
>
+------------+----------+--------------------+-------------------+--------
> --
> --------+-------------------+
> | 09/01/2004 | 17:28:27 | 02327125           | 00018151635       | Start
> |                   |
> | 09/01/2004 | 19:00:34 | 02320176           | 01181471822125    | Start
> |                   |
> | 09/01/2004 | 19:10:08 | 17113080           | 01022586815       | Start
> |                   |
>  09/01/2004 | 20:28:27 | 02327125           | 00018151635       | Sop
> |                   |
> | 09/01/2004 | 21:00:34 | 02320176           | 01181471822125    | Stop
> |                   |
> | 09/01/2004 | 22:10:08 | 17113080           | 01022586815       | Stop
> |                   |
> 
> 
> Thanking you all in advance.
> 
> Karma
> 
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1

Thread
Problem on InnoDB - Tablespace enough but engine said table fullAdy Wicaksono1 Sep
Re: Problem on InnoDB - Tablespace enough but engine said table fullHeikki Tuuri2 Sep
  • Re: Problem on InnoDB - Tablespace enough but engine said table fullAdy Wicaksono3 Sep
    • Re: Problem on InnoDB - Tablespace enough but engine said table fullAdy Wicaksono3 Sep
      • HELP ME WITH THISKarma Dorji3 Sep
        • Re: HELP ME WITH THISRoger Baklund3 Sep
      • Re: Problem on InnoDB - Tablespace enough but engine said table fullHeikki Tuuri3 Sep
        • Re: Problem on InnoDB - Tablespace enough but engine said table fullAdy Wicaksono4 Sep
RE: HELP ME WITH THISPeter J Milanese3 Sep
  • Re: HELP ME WITH THISDobromir Velev3 Sep
  • Re: HELP ME WITH THISKarma Dorji4 Sep