Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

how to subtract one date to another using php

Tags:

php

I want to subtract one date to another using php and display result in the days - hours - min - sec format. How i do this using php . I tried this using time stamp but it does not give proper values. please give suggestion

For ex : from date 2012-04-27 19:30:56 to date 2012-04-27 19:37:56

i used this code

if(strtotime($history['datetimestamp']) > strtotime($lasttime)) {

                 $totalelapsed1 = (strtotime($history['datetimestamp'])-strtotime($lasttime)); 




                     if($totalelapsed1 > 60 ) {
                         $sec = $totalelapsed1%60;
                         $min = round($totalelapsed1/60 , 0);

                         $minute = $min + $minute;
                         $second = $sec + $second;

                        // echo $min. " min " .$sec." sec";

                     } else {
                         //echo "0 min " . $totalelapsed1." sec";

                         $minute = 0 + $minute;
                         $second = $totalelapsed1 + $second;

                    }



                } else {
                     $minute = 0 + $minute;
                     $second = 0 + $second;
                    // echo "0 min 0 sec";
                }
like image 668
meenakshi Avatar asked Dec 06 '22 14:12

meenakshi


1 Answers

From how to subtract two dates and times to get difference by VolkerK:

You have to use like this:-

<?php

//$now = new DateTime(); // current date/time
$now = new DateTime("2010-07-28 01:11:50");
$ref = new DateTime("2010-07-30 05:56:40");
$diff = $now->diff($ref);
printf('%d days, %d hours, %d minutes', $diff->d, $diff->h, $diff->i);
prints 2 days, 4 hours, 44 minutes

see http://docs.php.net/datetime.diff

edit: But you could also shift the problem more to the database side, e.g. by storing the expiration date/time in the table and then do a query like ... WHERE key='7gedufgweufg' AND expires<Now() Many rdbms have reasonable/good support for date/time arithmetic.

Link Url:- how to subtract two dates and times to get difference

http://www.webpronews.com/calculating-the-difference-between-two-dates-using-php-2005-11

like image 117
Javascript Coder Avatar answered Dec 10 '22 13:12

Javascript Coder