手机销售心得体会:一条SQL语句
来源:百度文库 编辑:中科新闻网 时间:2024/05/05 09:00:39
在DELPHI中查询日期在2个DateTimePicker之间的SQL语句怎么写
怎么样才能让字段类型匹配???
between '''+DateTimePicker1+''' and '''+DateTimePicker1+'''
我早试了 不行```
仔细看了问题再回答行不`
怎么样才能让字段类型匹配???
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个'