Dear All,
I have a question in mysql and iam not very sure if this is the right plcae to post my question.Anyways, my question is

I have two rows where i have two instances of time.(iam posting my table below). I would like to know how to retreive the time difference between the two.I googled n gotta know that TIMESTAMPDIFF function can be used.


+----+--------+----------+----------+-------------------------------------------
| C1 | C2| A2.|...........time...... |.A3..|.A4.|.A5|dst_domain|
+----+--------+----------+----------+--------------------------------------------
| 26 |BYE|200 | OK| 2009-11-18 14:21:18 | 200 |100 |100| 192.168.64.142 |
| 25 |ACK|200 | OK| 2009-11-18 14:21:15 | 100 |200 |200| 192.168.64.75 |

In short i would like to get the time difference between 14:21:18 and 14:21:15

Just curious but what kind of database is that? I'm just now using postgresql and learning the ropes. That database looks interesting. Is it for benchmarking networking latencies?

NOt really.. this is related to telephone-billing... any ideas how to retreive the duration(the difference between the two time inputs given)?..

Many functions available in mysql

TIME FUNCTION
TIMEDIFF
TIMESTAMP FUNCTION
TIMESTAMPADD
TIMESTAMPDIFF
TIME_FORMAT
TIME_TO_SEC

If they're stored properly as date/time fields, you might just try a simple subtract as well.
DBs usually internally store the date/times as numbers.

The problem would be that they are in separate rows and queries are usually row-based.
You may need some stored procedure for that, or use some custom scripting, rather than the DB.

For what purpose do you need the time diff?