1.时间非变量
SELECT * FROM AlarmRecordTable WHERE dateTime BETWEEN '2023-06-13' AND '2023-06-14'
2.时间是个变量,取自时间选择器中,如下
起始时间
结束时间
string sql = "select * from AlarmRecordTable" + " where dateTime" + " between '" + startDateTimePicker.Value.ToString("yyyy-MM-dd HH:mm:ss") + "'" + " and '" + endDateTimePicker.Value.ToString("yyyy-MM-dd HH:mm:ss") + "'";
tips:时间必须带单引号
参考链接:C#从SQL Server数据库查询选定日期范围内的相关数据—DateTimePicker控件_c# datetime条件查询_菜鸟学飞ing去看世界的博客-CSDN博客