query+access 总是提示时间格式无效，我应该怎么修改下面的两行代码？再线等待
这是我sql中的代码：
query1.ParamByName('begintime').asdatetime:=DateTimePicker3.Date;
query1.ParamByName('endtime').asdatetime:=DateTimePicker4.Date;
query1.sql.add(select * from view where shijian between :begintime and :endtime );
如果在access中怎么修改？
问题点数：0、回复次数：4Top
1 楼47522341（睡到8：30）回复于 2003-11-01 16:16:43 得分 0
query1.sql.add('select * from view where shijian between :begintime and :endtime ');
query1.ParamByName('begintime').value := datetostr(DateTimePicker3.Date);
query1.ParamByName('endtime').value := datetime(DateTimePicker4.Date);
Top
2 楼pwzhu666（暴龙）回复于 2003-11-01 16:20:25 得分 0
query1.sql.add('select * from view where shijian between :begintime and :endtime ');
query1.ParamByName('begintime').value := datetostr(DateTimePicker3.Date);
query1.ParamByName('endtime').value := datetime(DateTimePicker4.Date);
open;
你搞反了阿 兄弟阿Top
3 楼hare007（hare）回复于 2003-11-01 17:05:23 得分 0
同上
Top
4 楼konhon（优华）回复于 2003-11-01 19:34:24 得分 0
query1.sql.add('select * from view where shijian between :begintime and :endtime ');
query1.ParamByName('begintime').value := datetostr(DateTimePicker3.Date);
query1.ParamByName('endtime').value := datetime(DateTimePicker4.Date);
Top
