TalkPHP - Special Date Calculation ...

TalkPHP (http://www.talkphp.com/forums.php)

- Absolute Beginners (http://www.talkphp.com/absolute-beginners/)

- - Special Date Calculation ... (http://www.talkphp.com/absolute-beginners/5794-special-date-calculation.html)

pepelepew1962

02-20-2011 01:56 AM

Special Date Calculation ...

Hello, I REALLY need some help creating a special date calculation. I want to calculate the difference between
2 mysql fields but display the difference as:
//
//
02:19:21
//
02 is days
19 is hours
21 as minutes
//
//
$Dater01 = $row['tblTabler00_Dater01']; //2010-12-16 23:45:00
$Dater02 = $row['tblTabler00_Dater02']; //2010-12-14 04:24:00
//
$Dater03 = $Dater01 - $Dater02
//
Important is that a negative amount is valid, meaning it is overdue. Any help would be greatly appreciated.
//
Regards,

maeltar

02-20-2011 09:53 AM

MySQL datediff() and MySQL timediff() could be your friends here, just parse the returned values into the format you need..

All times are GMT. The time now is 09:51 AM.