mysql: curdate()-2005-05-14

lmb

curdate()=2005-06-14
end_date1=2005-06-13
end_date1=2005-06-10
end_date1=2005-05-13


curdate()-end_date1= 1
curdate()-end_date2-10 = 4
curdate()-end_date3 ＝ 1++

我要那出相差多少天，
谁可以帮帮忙？

answer: to_days(curdate()-to_days(end_date1)

[ Last edited by lmb on 20-6-2005 at 09:33 PM ]

flashang

SELECT CURDATE( ) - '20050613'
=1

SELECT curdate( ) - '20050610'
= 4

SELECT curdate( ) - '20050514'
= 100


你可以用 phpMyAdmin 来测试你的 SQL

microSys

SELECT DATEDIFF(CURDATE( ) ,'2005-06-13');
Only support in MySQL 4.1.1