mysql去两个时间的差异_MySql在两个时间戳之间的差异天？

如何获得两个时间戳之间的差异天？我应该使用datetime列吗？

我把我的列切换到datetime。简单的减法似乎不给我一个结果在几天。

mysql> SELECT NOW(), last_confirmation_attempt, NOW() - last_confirmation_attempt AS diff FROM DateClubs HAVING diff IS NOT NULL ;

+---------------------+---------------------------+-----------------+

| NOW() | last_confirmation_attempt | diff |

+---------------------+---------------------------+-----------------+

| 2010-03-30 10:52:31 | 2010-03-16 10:41:47 | 14001084.000000 |

+---------------------+---------------------------+-----------------+

1 row in set (0.00 sec)

我不认为差异在几秒钟内，因为当我把差异一秒钟的数量(86,400)，我没有得到一个有道理的答案：

mysql> SELECT NOW(), last_confirmation_attempt, ( NOW() - last_confirmation_attempt) / 86400 AS diff FROM DateClubs HAVING diff IS NOT NULL ;

+---------------------+---------------------------+----------------+

| NOW() | last_confirmation_attempt | diff |

+---------------------+---------------------------+----------------+

| 2010-03-30 10:58:58 | 2010-03-16 10:41:47 | 162.0568402778 |

+---------------------+---------------------------+----------------+

1 row in set (0.00 sec)