我得 语句如下
COleDateTime dtTime;
....
strSQL.Format(_T("select * from mytable where time<'%s' "),dtTime.Format(_T("%Y-%m-%d %H:%M:%S")));比如 select * from mytable where time<'2003-1-9 00:00:00'
报错 “标准语句的数据类型不匹配”
在Access中上就SQL语句真么写????
COleDateTime dtTime;
....
strSQL.Format(_T("select * from mytable where time<'%s' "),dtTime.Format(_T("%Y-%m-%d %H:%M:%S")));比如 select * from mytable where time<'2003-1-9 00:00:00'
报错 “标准语句的数据类型不匹配”
在Access中上就SQL语句真么写????
select * from mytable where time<#2003-1-9 00:00:00#
不用‘’ 用 ##