Jump to content


Photo

Find the ammount of days, hours and minutes between 2 dates?


  • Please log in to reply
2 replies to this topic

#1 onemind

onemind
  • Members
  • PipPip
  • Member
  • 28 posts

Posted 24 July 2006 - 08:52 AM

Hi,

I have a datetime field in a mysql database and i want to output how many days, hours and minutes are left between the current date and the future date.

So far i just convert the datettime to a timestamp like so: $start = strtotime($began); 

Where $began is the current time, basically i just need to know how to convert a timestamp to days, hours ect If i was to minus the current timestamp from the future timestamp.

Any help would be greatly appreciated.

Thanks :)

#2 hussain

hussain
  • Members
  • PipPip
  • Member
  • 11 posts

Posted 24 July 2006 - 09:19 AM

try this

strftime ("Y-m-d h:i:m",  timestamp)

#3 onemind

onemind
  • Members
  • PipPip
  • Member
  • 28 posts

Posted 24 July 2006 - 09:43 AM

Thanks, i figured it out.

$diff = $ends-$now;

$days = intval($diff/24/60/60);
$remain=$diff%86400;
$hours=intval($remain/3600);
$remain=$remain%3600;
$mins=intval($remain/60);

:)




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users