时间格式转换 谢谢帮忙
现在数据库里的记录是
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 是时间字段， 谢谢帮忙
[解决办法]
"select USERID,CHECKTIME,NAME from CX1 where NAME = ' "&bb& " ' and format(CHECKTIME, 'yyyy-mm-dd ') = '2007-05-11 ' "
或
"select USERID,CHECKTIME,NAME from CX1 where NAME = ' "&bb& " ' and format(CHECKTIME, 'yyyy-mm-dd ') = ' " & 你的日期变量值 & " ' "
