你時間不能定死的吧,用兩個DTPick1,DTPick2.把兩個時間值傳回來 sSql = "Select * from ( DTPick Between ? And ? ) Order By ?"
问题一:select * from table where mydate between '2003-12-11' and '2003-12-28' 问题二:convert(varchar,year('2003-12-12'))+'年'+convert(varchar,month('2003-12-12'))+'月'+convert(varchar,day('2003-12-12'))+'日'
谢谢 luckduck(菠萝蜜),formatwj(wj)
sSql = "Select * from ( DTPick Between ? And ? ) Order By ?"
问题二:convert(varchar,year('2003-12-12'))+'年'+convert(varchar,month('2003-12-12'))+'月'+convert(varchar,day('2003-12-12'))+'日'