DATEDIFF http://dp.pt.xiaomi.com/task/25382346 -- (end,start) SELECT DATEDIFF('2008-12-30','2008-12-29') AS DiffDate