TalkPHP - View Single Post

pepelepew1962 · 02-20-2011, 01:56 AM

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,

02-20-2011, 01:56 AM	#1 (permalink)
pepelepew1962 The Wanderer Join Date: Jan 2010 Posts: 13 Thanks: 0	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,