下面语法正确吗？

[sydeng]

string ls_sj1,ls_sj2
if rb_3.checked = true then
ls_new_sql = left(ls_old_sql,708) + ' and ( ( ptd.ptsj >= date("'+ 　　　ls_sj1 +'" )) and ( ptd.ptsj <= date("'+ ls_sj2 + '" ) ) ORDER BY ptd.zzlh ASC '
end if
dw_1.setsqlselect(ls_new_sql)
dw_1.retrieve()

运行，提示错误：select error:"date" is not a recognized function name
如何修改？

[kilojin]

ls_where = ls_where + " (" + ls_col_name +" >= " + "datetime('" + ls_value + "') and ("+ls_col_name +"<=datetime(date('"+ls_value+"'),time('23:59:59'))))"

用Datetime不是Date

[huangxinru]

试一下
ls_new_sql = left(ls_old_sql,708) + ' and ( ptd.ptsj >= ‘+date(ls_sj1) and ( ptd.ptsj <= date(ls_sj2) ORDER BY ptd.zzlh ASC '

[zxjnew]

你用的什么数据库哦 sqlserver中是用cast或者convert转换 oracle用的是to_date转换

[zxjnew]

哦 看错了 先转换了在放进去的 呵呵 还是用
ls_new_sql = left(ls_old_sql,708) + ' and ( ptd.ptsj >=' +date(ls_sj1) +'and ( ptd.ptsj <='+ date(ls_sj2) +' ORDER BY ptd.zzlh ASC'
是语法的问题了！！