datetime dat_kssj,dat_jssj
string old_sql,new_sql
new_sql=""
em_kssj.getdata(dat_kssj)
em_jssj.getdata(dat_jssj)
old_sql=dw_1.getsqlselect() //获取sql
new_sql=old_sql+" where 1=1 and to_char(bqzxrq,'yyyy-mm-dd hh:mm') >= '"+em_kssj.text+"' and to_char(bqzxrq,'yyyy-mm-dd hh:mm') < '"+em_jssj.text+"'"
dw_1.setsqlselect(new_sql)
dw_1.settransobject(sqlca)
dw_1.retrieve()
你用的应该是oracle数据库，试试这么写
datetime dat_kssj,dat_jssj
string old_sql,new_sql
new_sql=""
em_kssj.getdata(dat_kssj)
em_jssj.getdata(dat_jssj)
old_sql=dw_1.getsqlselect() //获取sql
new_sql=old_sql+" where 1=1 and to_char(bqzxrq,'yyyy-mm-dd hh24:mi') >= '"+em_kssj.text+"' and to_char(bqzxrq,'yyyy-mm-dd hh24:mi') < '"+em_jssj.text+"'"
dw_1.setsqlselect(new_sql)
dw_1.settransobject(sqlca)
dw_1.retrieve()
oracle的日期格式转换，时分应该为 hh24:mi格式，如果用12小时制，可以用hh:mi
你再试试，如果还有问题再找我