在表中保存了一个datetime类型字段MemoTime,如2009-10-19 9:33:59,定义了一个时间变量T(T的格式如2009:10:20)
string cmdtxt = "SELECT Title AS 标题, Content AS 内容, MemoTime AS 时间 FROM tb_Memorandum where A and MemoUser='" + ItemClass.PropertyClass.SendNameValue + "' ";怎么样在A中再加入一个条件来查询MemoTime字段中年月日等于T的记录
string cmdtxt = "SELECT Title AS 标题, Content AS 内容, MemoTime AS 时间 FROM tb_Memorandum where A and MemoUser='" + ItemClass.PropertyClass.SendNameValue + "' ";怎么样在A中再加入一个条件来查询MemoTime字段中年月日等于T的记录
COVNERT(VARCHAR(10),MemoUser,120)
这样是年月日格式的
ItemClass.PropertyClass.SendNameValue 这个也转换成YYYY-MM-DD格式的或用DATEDIFF(DD,TIME1,TIME2)=0