How to deal with DATE-type in MYSQL & PHP?

Solution:

That's a display problem. Use mysql's function to convert to whatever your display requirements are, e.g.

SELECT date_format(datefield, '%d-%m-%Y'), ...
Copy code

You can use strtotime to convert a string representation of the date to an actual date object in php, then use the date function to spit out the date as any string format you wish. Also, you can bestrtotime to perform date calculations. Additional information can be found at this blog post.

$phpDate = strtotime($stringDateFromDb);
date('d-m-y', $dateFromDb);
strtotime('-3 days', strtotime($stringDateFromDb));
Copy code

Solution:

Here is an example for a way to do it:

$date_str = '2012-05-20'; //you get it from db
$date_now = strtotime($date_str);  //convert it to unix timestamp
$yesterday=$date_now-24*60*60;  //make calculations
echo 'yesterday was: '. date('d-m-Y',$yesterday);  //date() returns the date in format you need
Copy code

Further example here: How to calculate the difference between two dates using PHP?