请问delphi中的sql语句如何用date形?
我用过 query1.sql.add('select * from tdate where tday='+datetostr(datetimepacker1.date)); query1.sql.add('select * from tdate where tday="'+datetostr(datetimepacker1.date+'"'));
query1.sql.add('select * from tdate where tday='+datetimepacker1.date);这几种方法都不行,请问上面的代码如何写?
我用过 query1.sql.add('select * from tdate where tday='+datetostr(datetimepacker1.date)); query1.sql.add('select * from tdate where tday="'+datetostr(datetimepacker1.date+'"'));
query1.sql.add('select * from tdate where tday='+datetimepacker1.date);这几种方法都不行,请问上面的代码如何写?
解决方案 »
- 请教 idHTTP接收网页源代码问题
- 求助,dlephi中一个socket的问题
- 刚接触delphi图形方面的内容,提个最菜的问题
- 人民币1500请精通脱壳反汇编的朋友写一个简单程序
- 问一下,什么方法可以把字符串"猴子"变为"%BA%EF%D7%D3"?
- 谁有delphi深度历险电子书
- 什么数据库在win 98以上视窗系统上肯定有?
- 100分我想问一个关于Indy 10中Idhttp组件POST成功后服务器自动断开连接后返回Connection Closed Gracefully的问题
- Delphi数据库打印的方法?
- 组件安装出错???
- 关于 Data Modle 的疑问
- 如何找出局域网中安装了我的应用程序服务器的所有机器
然后
query1.sql.add('select * from tdate where tday='+''''+datetimetostr(datetimepacker1.date)+'''');
Query1.ParamByName('a').AsDate:=datetimepicker1.date;
query1.sql.add('select * from tdate where tday=:date');
Query1.ParamByName('date').AsDate:=datetimepicker1.date;
1
query1.sql.add('select * from tdate where tday=#'+datetostr(yourDateV)+'#');
2
query1.sql.add('select * from tdate where tday=:date');
Query1.ParamByName('date').AsDate:=yourDate;
Query1.ParamByName('date').AsDate:=datetimepicker1.date;
或者
//access
query1.sql.add('select * from tdate where tday=#'+datetostr(datetimepacker1.date)+'#');
//sql
query1.sql.add('select * from tdate where tday='''+datetostr(datetimepacker1.date)+'''');
// sql de
query1.sql.add('select * from tdate where tday='+datetostr(datetimepacker1.date)+');