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:[EMAIL PROTECTED] > Sent: Friday, September 03, 2004 5:06 AM > To: [EMAIL PROTECTED] > 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/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
