date difference Calculate days from two dates

[684425]

I have date stored in database in any of the given forms 2020-06-01, 2020-05-01 or 2019-04-01

I want to compare the old date with current date 2020-06-14

And the result should be in days.

Any help please?

PS: I want to do it on php side. but if its possible to do on database side (I am using myslq) please share both ways🙂

Edited June 14, 2020 by 684425

[gw1500se]

Assuming PHP 5.3 or better and db date is in the format Y-m-d.

$fromdb=new DateTime($datefromdb);
$today=new DateTime();
$diff=$fromdb-$today;
print("Difference is ".$diff.d." days);

Note the result can be negative days.

[Barand]

Use $diff->days.

$dt1 = new DateTime('2020-05-01');
$diff = $dt1->diff(new DateTime())->d;       //--> 14;
$diff = $dt1->diff(new DateTime())->days;    //--> 44;

->d gives the days as in "1 month 14 days"

->days gives the total days

Using SQL:

select datediff(curdate(), '2020-05-01') as days;
+------+
| days |
+------+
|   44 |
+------+

 

Edited June 14, 2020 by Barand