求一条SQL的删除语句，删除某天数据

[nandi_1]

数据库中日期时间是包括时分秒的，想要删除某天的记录，怎么写？

[nandi_1]

补充：
我在VB.net中是这样写的：
MyOledbCommand.CommandText = "Delete From 仓测量记录 " _
& "WHERE convert(date,日期)=#" _
& lstDate.SelectedItem.ToString _
& "# "
出错，出错信息是“未定义convert函数”。

[wwwwb]

后台什么数据库

[nandi_1]

ACCess

[ACMAIN_CHM]

MyOledbCommand.CommandText = "Delete From 仓测量记录 " _
& "WHERE int(date)=#" _
& lstDate.SelectedItem.ToString _
& "# "

[wwwwb]

MyOledbCommand.CommandText = "Delete From 仓测量记录 " _
& "WHERE format([date],'yyyy-mm-dd')='" _
& lstDate.SelectedItem.ToString _
& "' "

[nandi_1]

用了ACMAIN_CHM的语句问题解决了，wwwwb的语句没成功，谢谢两位大侠！