How do i use php code to do $date - $singup_date

[lkh11lkh]

hi

 

if my $date is 2009-02-21 01:30:00

if my $signup_date is 2009-02-21 01:00:00

the total is 30minutes.

 

How do i use php code to do $date - $singup_date?

 

is there any help?

 

thanks alot

 

lkh

 

[premiso]

If you are pulling this from mysql, use that to do it given the function DATE_SUB.

[sasa]

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_timediff

[lkh11lkh]

thanks premiso & sasa

 

but i still did not understand .

 

is it i must convert $date & $signup_date into unix_timestamp?

if yes, is there sample or example link?

 

thanks

[l0ve2hat3]

<?php
$date = "2009-02-21 01:30:00";
$signup_date= "2009-02-21 01:00:00";

echo (strtotime($date)-strtotime($signup_date))/60;

?>

[lkh11lkh]

hi

 

<?php

$date = "2009-02-21 01:30:00";

$signup_date= "2009-02-21 00:00:00";

 

echo (strtotime($date)-strtotime($signup_date))/60;

 

?>

 

if total is 90mins

how do i convert from 90mins to 1hr 30mins?

 

thanks for your help

 

 

[jitesh]

$var = 90; // mins

 

$str = floor($var/60)." hours ".($var%60)." mins";