Time Diff

NZ_Kiwis

I've got Time(); and a date stamp for something in the future.

How can i display how many days, hours seconds etc are left between the two dates?

bradgrafelman

One way would be to use the DateTime::diff() method (see: [man]datetime.diff[/man]).

NZ_Kiwis

that works for dates, but what if i'm looking for hours, minutes or seconds within the same day.

bradgrafelman

Hmm.. so it does. Oops!

I suppose you could instead use [man]strtotime/man to covert the two dates and then find the number of seconds by which they differ.

EDIT: This date you've got.. it doesnt happen to be coming from a MySQL DB, does it?

NZ_Kiwis

Would this work?

 <?php
	$int = $Close - $Time;

$Weeks = floor($int / 604800);
$int = $int - (604800 * $Weeks);

$Days = floor($int / 86400);
$int = $int - (86400 * $Days);

$Hours = floor($int / 3600);
$int = $int - (3600 * $Hours);

$Minutes = floor($int / 60);
$int = $int - (60 * $Minutes);

$Seconds = $int;

echo $Weeks . " weeks " . $Days . " days " . $Hours . " hours " . $Minutes . " minutes " . $Seconds;
?>

Weedpacket

Have you tried it?

NZ_Kiwis

yeah seems to work, was looking to see if anyone could see any issues with it.

Weedpacket

Well, you could go in the reverse direction. The duration is a certain number of seconds. Dividing that by 60 gives a certain number of minutes plus a remainder. If you could get the remainder in advance, then subtracting it would mean the division could be done exactly. PHP has an operator for the job.

$Duration = $Close - $Time; // Entire duration in whole seconds

$Seconds = $Duration &#37; 60;
$Duration = ($Duration - $Seconds) / 60; // Entire duration in whole minutes

$Minutes = $Duration % 60;
$Duration = ($Duration - $Minutes) / 60; // Entire duration in whole hours

$Hours = $Duration % 24;
$Duration = ($Duration - $Hours) / 24; // Entire duration in whole days

$Days = $Duration % 7;
$Duration = ($Duration - $Days) / 7; // Entire duration in whole weeks

$Weeks = $Duration;

johanafm

NZ_Kiwis;10982063 wrote:
that works for dates, but what if i'm looking for hours, minutes or seconds within the same day.

This is for datetimes, so wether it's a difference of days or seconds doesn't really matter.

$d1 = new DateTime('2011-06-12 13:00');
$d2 = new DateTime('2011-06-13 15:20');

$i = $d2->diff($d1);

echo $i->format('%Y-%M-%D %H:%I:%S');

output

00-00-01 02:20:00

Which tells you the time difference is 1 day, 2 hours, 20 minutes. If the datetimes are within the same day, there's a 2 hour 20 minute difference.

Or, if what you meant when saying you have a time() and a datestamp is that you have number of seconds since... created by time() or mktime(), and a datetime

# or, if you have a time(), i.e. seconds since... combined with a datetime
$time = 1307962800;		# 2011-06-13 13:00:00, seconds since...
$d2 = new DateTime('2011-06-13 15:20:00');
$d1 = new DateTime(date('Y-m-d H:i:s', $time));

$i = $d2->diff($d1);
echo $i->format('%Y-%M-%D %H:%I:%S');

And even if you start with a datetime and an interval expressed in seconds, I still find it easier to use the built in functionality.

# or, if you have a time, datetime or whatever, combined with an interval in seconds
$time = 1307962800;		# 2011-06-13 13:00:00, seconds since...
$d1 = new DateTime(date('Y-m-d H:i:s', $time));

# Clone the first datetime
$d2 = new DateTime($d1->format('Y-m-d H:i:s'));
# add your interval expressed in seconds
$d2 = $d2->add(new DateInterval('PT8400S'));

# create an interval
/* Note that you can't directly do
 * $interval = new DateInterval(PT8400S');
 * since $interval->format() will show 8400 seconds and 0 for anything else
 */
$i = $d2->diff($d1);
echo $i->format('%Y-%M-%D %H:%I:%S');