CString sTime;
sTime = currentTime.Format("%Y-%m-%d %H:%M:%S");
sSQL.Format("SELECT * FROM clip2 WHERE starttime<=#%s#",sTime);
sTime = currentTime.Format("%Y-%m-%d %H:%M:%S");
sSQL.Format("SELECT * FROM clip2 WHERE starttime<=#%s#",sTime);
调试欢乐多
#1/30/2001#sSQL.Format("SELECT * FROM clip2 WHERE starttime<=#'%d'#",currentTime);
改成
sSQL.Format("SELECT * FROM clip2 WHERE starttime <= #%d/%d/%d'#",currentTime.GetMonth(),currentTime.GetDay(),currentTime.GetYear());
其实没必要用时间字段,我一般都是将CTime转换成整型在写入数据库,读出以后在重新构造成CTime