Question

怎么用2个datetimepicker查询时间段数据

str="select * from Furn_Info where Time between '"
+ this.dateTimePicker1.Value.ToString("yyyy-MM-dd hh:mm:ss")
+ "' and '" +
this.dateTimePicker2.Value.ToString("yyyy-MM-dd hh:mm:ss")
+ "'"; 用的是oracle数据库。求改正，求代码

Answer 1

"select * from Furn_info where Time >= '" +
this.dateTimePicker1.Value.ToString("yyyy-MM-dd hh:mm:ss") +
"' and Time <= '" +
this.dateTimePicker2.Value.ToString("yyyy-MM-dd hh:mm:ss") +
"'";

Answer 2

str="select * from Furn_Info where Time between to_date(this.dateTimePicker1.value,'yyyy-mm-dd hh24:mi') and to_date(this.dateTimePicker2.value,'yyyy-mm-dd hh24:mi')