计算mysql时间戳和php当前日期之间的天数[重复]

Question

This question already has an answer here:

• Finding the number of days between two dates 28 answers

I am getting php date with date("Y-m-d") as 2014-03-14 and

mysql timestamp is 2014-03-02 03:2:23

I want to get as 12 days.

</div>

Answer 1

SELECT DATEDIFF('2014-03-14',DATE(mysql_timestamp))