麻烦再说下我用DATE_sub应该怎么弄
我的查询字符串是这样写的
string dgvSql = "SELECT ProjectName as 模块,BugTitle as Bug标题,OpenedBy as 创建人,OpenedDate as 创建日期,ResolvedBy as 解决人,ResolvedDate as 解决日期,TIMEDIFF(ResolvedDate, OpenedDate) FROM bf_buginfo WHERE ProjectName ='"
+ BuildVersion.SelectedItem.ToString().Trim() + "' AND ResolvedBy = '" + lstbxUsername.SelectedItem.ToString().Trim() + "' AND OpenedDate >= '"
+ StartTime.Value.ToShortDateString() + "' AND ResolvedDate <= '" + EndTime.Value.ToShortDateString() + "';";