pb中日期型数据与sqlserver中的日期型数据的问题(在线)

[smilegw]

SELECT dwjf.jfyf,
dwjf.jzrq,
dwjf.jfrs,
dwjf.dwjf,
dwjf.grjf,
dwjf.znje,
dwjf.jffs,
dwjf.dwbh
FROM dwjf
WHERE ( dwjf.dwbh = :ls_dwbh ) AND
( dwjf.jfyf between :ls_qsrq AND :ls_zzrq )
注：string ls_dwbh
datetime ls_qsrq,ls_zzrq
在数据窗口中检索时
dw_1.retrieve("002","2001-01-01 00:00:00",","2001-01-01 00:00:00")
出现错误，提示数据类型不匹配!
请高手指点
我用pb8.0与sqlserver2000

[eminena]

试试:

dw_1.retrieve("002",2001-01-01 00:00:00,2001-01-01 00:00:00)

[dotnba]

dw_1.retrieve("002",datetime(date("2001-01-01")),",datetime(date("2001-01-01")))