手机销售心得体会:一条SQL语句

来源:百度文库 编辑:中科新闻网 时间:2024/05/05 09:00:39
在DELPHI中查询日期在2个DateTimePicker之间的SQL语句怎么写
怎么样才能让字段类型匹配???
between '''+DateTimePicker1+''' and '''+DateTimePicker1+'''
我早试了 不行```
仔细看了问题再回答行不`

应该要先转换成字符串吧,不然日期和字符怎么加

between '''+datetimetostr(DateTimePicker1.datetime)+''' and '''+datetimetostr(DateTimePicker1.datetime)+''''

select datetime
from DELPHI
where datetime between DateTimePicker1 and DateTimePicker2

select *
from table1
where 日期字段 between '''+DateTimePicker1+''' and '''+DateTimePicker1+'''

注意是3个'