时间格式转换 多谢帮忙

时间格式转换 谢谢帮忙
现在数据库里的记录是
2007-5-11   08:50:30  
2007-5-11   14:33:33
我想通过查询   2007-5-11   把数据调出来
我用的是access数据库，我用convert函数，好象不支持~
  "select   USERID,CHECKTIME,NAME   from   CX1   where   NAME   =   ' "&bb& " '   and   ？   =
  # "&StrDate& "#   "

CHECKTIME   是时间字段，   谢谢帮忙



[解决办法]
StrDate=StrDate& " "& "00:00:00 "
enddate=dateadd( "s ",-1,dateadd( "d ",1,strdate))
"select USERID,CHECKTIME,NAME from CX1 where NAME = ' "&bb& " ' and checktime between # "&StrDate& "# and # "&enddate& "# "
[解决办法]
http://www.jw112.com/t_itme.asp?id=4
以上地址是ASP,最常用的日期函数.



[解决办法]
Select USERID,CHECKTIME,NAME from CX1 where NAME = ' "&bb& " ' and CheckTime like '%StrDate% '