sql日期函数总结

access

        this.GridView1.DataSource = mydb.getDataSet("select * from web_product_order where o_create between dateadd("d",-1,"" + Calendar1.Value + "") and dateadd("d",1,"" + Calendar2.Value + "")" + kc + zt + " order by id desc");

sql中 dateadd(day,3,1992-10-18)

select top 1 convert(varchar(10),vtime,20),count(*) as c
from CounterView
group by vtime
order by c desc