试试这个: string sql = string.Format(@" SELECT * FROM table1 WHERE [批复日期] BETWEEN '{0:yyyy-MM-dd}' AND '{1:yyyy-MM-dd}' ", dt1.Value, dt2.Value);或者这样: string sql = string.Format(@" SELECT * FROM table1 WHERE [批复日期] BETWEEN '{0:yyyy-MM-dd}' AND '{1:yyyy-MM-dd} 23:59:59' ", dt1.Value, dt2.Value);
string sql = string.Format(@"
SELECT *
FROM table1
WHERE [批复日期] BETWEEN '{0:yyyy-MM-dd}' AND '{1:yyyy-MM-dd}'
",
dt1.Value, dt2.Value);或者这样:
string sql = string.Format(@"
SELECT *
FROM table1
WHERE [批复日期] BETWEEN '{0:yyyy-MM-dd}' AND '{1:yyyy-MM-dd} 23:59:59'
",
dt1.Value, dt2.Value);