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
