Calculate hours between to dates.

[huxphlux]

Hello everyone, had a look around on google an such, find some there, but

it didnt help me at all. But hopefully someone here could help me.

All help is really appriciated!

 

So, to the "problem" or what i shall call it.

 

I got too different dates in a database. Ive fetched them from it and stored it into a variabels. Lets say like this.

$date1 = 2010-07-20 20:00:00

$date2 = 2010-07-21 20:00:00

 

So, these dates is just examples. So what i want to do is to find out how many hours it is between them and store

the hours into a variable. And yes, they are stored like that in the database, so its not unixtime.

 

If you need to know more, please ask.

 

Great thanks.

[PFMaBiSmAd]

Just do directly it in your query when you retrieve the data - http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_timestampdiff

 

Use HOUR for the unit parameter.

[Cagecrawler]

Use DateTime::diff (or it's procedural equivalent date_diff)

$datetime1 = new DateTime('2009-10-11');
$datetime2 = new DateTime('2009-10-13');
$interval = $datetime1->diff($datetime2);
echo $interval->format('%R%d days');

$datetime1 = date_create('2009-10-11');
$datetime2 = date_create('2009-10-13');
$interval = date_diff($datetime1, $datetime2);
echo $interval->format('%R%d days');

[huxphlux]

Oh thanks, still got one more question, is it possible to use like the current date in the query and compare it with one date in the database?

 

 

[huxphlux]

And btw, is not that compareing and give you how many days? I would want hours..

 

quote author=Cagecrawler link=topic=304782.msg1441660#msg1441660 date=1279582838]

Use DateTime::diff (or it's procedural equivalent date_diff)

$datetime1 = new DateTime('2009-10-11');
$datetime2 = new DateTime('2009-10-13');
$interval = $datetime1->diff($datetime2);
echo $interval->format('%R%d days');

$datetime1 = date_create('2009-10-11');
$datetime2 = date_create('2009-10-13');
$interval = date_diff($datetime1, $datetime2);
echo $interval->format('%R%d days');

[huxphlux]

Solved with a timestampdiff. thanks for all the help! If someone want or need the code line so post.