澳洲精算师考试:一条SQL语句

来源:百度文库 编辑:查人人中国名人网 时间:2024/05/05 05:00:37
在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个'