假如opentime为所查询的字段,那么这条sql语句是什么?请写完整一点嘛, 马上给分 "select * from table where opentime
DateTime StartDate= new DateTime("2002/08/01"); DateTime EndDate = new DateTime("2002/08/31");select * from tablename where (databasedate>StartDate) and(databasedate<EndDate)
int mon=DateTime.Now.Month; string strSql = "select * from t_table where month(dTime)='"+mon+"'";
DateTime StartDate= new DateTime("2002/08/01"); DateTime EndDate = new DateTime("2002/08/31");select * from tablename where (databasedate>StartDate) and(databasedate<EndDate)STARTDATE和ENDDATE可以根据当前的月份来生成嘛!
还问个简单问题,不好意思 delsql="delete * from feeinfo where endtime='"+gettime+"'"; 其中endtime为日期字段,gettime为所取得的日期,但是字符串,应该怎么改啊? 好象没有把字符串改为datatime的方法
还问个简单问题,不好意思 delsql="delete * from feeinfo where endtime='"+gettime+"'"; 其中endtime,gettime都为日期字段,为什么会有错呢?
改为: delsql="delete * from feeinfo where endtime='"& cdate(gettime) &"'"
找不到cdate函数 gettime已经是日期类型了,但还是有错,为什么?
语法错误吧 试试:delsql="delete from feeinfo where endtime='"+gettime+"'";
马上给分
"select * from table where opentime
DateTime EndDate = new DateTime("2002/08/31");select * from tablename where (databasedate>StartDate) and(databasedate<EndDate)
string strSql = "select * from t_table where month(dTime)='"+mon+"'";
DateTime EndDate = new DateTime("2002/08/31");select * from tablename where (databasedate>StartDate) and(databasedate<EndDate)STARTDATE和ENDDATE可以根据当前的月份来生成嘛!
delsql="delete * from feeinfo where endtime='"+gettime+"'";
其中endtime为日期字段,gettime为所取得的日期,但是字符串,应该怎么改啊?
好象没有把字符串改为datatime的方法
delsql="delete * from feeinfo where endtime='"+gettime+"'";
其中endtime,gettime都为日期字段,为什么会有错呢?
改为:
delsql="delete * from feeinfo where endtime='"& cdate(gettime) &"'"
gettime已经是日期类型了,但还是有错,为什么?