strSql.Append(" CreatedDate >=convert(varchar(19), '" + strWhere + "'+' 00:00:00', 121) ");
strSql.Append(" CreatedDate <=convert(varchar(19), '" + strWhere + "'+' 23:59:59', 121)) ");
转载于:https://www.cnblogs.com/xw2cc1314/archive/2011/05/25/2056648.html