Question

用mysql数据库怎样计算2个日期字段的天数差

Answer 1

select datediff(now(),'2013-4-21') as 和当前时间相差多少天

Answer 2

TO_DAYS(date字段1) - TO_DAYS(date字段2)

Answer 3

转为时间戳 相减以后得出秒数 在用秒数 除以86400 得出天数

Answer 4

SELECT DATEDIFF('2008-12-30','2008-12-29') AS DiffDate
结果是
DiffDate
1