还是问这里来了

[ziling1250]

SELECT * FROM view where (TO_DAYS(vtime)>=TO_DAYS(2000-12-12)) and (TO_DAYS(vtime)<=TO_DAYS(2005-12-12)) and flag=9 ORDER BY id DESC
数据库里如 vtime 2003-02-26 15:11:36
怎么一条记录都找不出来啊？
运行无误

[xuzuning]

SELECT * FROM view where (TO_DAYS(vtime)>=TO_DAYS('2000-12-12')) and (TO_DAYS(vtime)<=TO_DAYS('2005-12-12')) and flag=9 ORDER BY id DESC