Getting elapsed time between two MySQL time fields
| From: | Tom Beidler | Date: | Mon, 31 Dec 2001 21:51:05 +0000 |
| Subject: | Getting elapsed time between two MySQL time fields | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-79149@lists.php.net to get a copy of this message | ||
I have some records in a MySQL database that store a start and stop time. In
my display page that displays the record info I would like to use PHP to
find the elapsed time between the two fields. So if I had;
Start 13:44:20
Stop 13:49:25
Possibly use a function to calculate
Elapsed 5:05
Do I need to do this in MySQL?
Thanks,
Tom