select fssj,dxzx_id,fwq_ip,dx_xh,ydz,mddz,dxnr,dxlx,bmlx,dxfl,ydz_sd,mddz_sd,fxr_szd,
sxr_szd,fx_dxzx,sx_dxzx from ls_dxx where bmlx=bmlx and dxfl=dxfl and dxlx=103 or
dxlx=203 or dxlx=201 and ydz_sd='2' or mddz_sd='3' and fssj>='2005-07-30 08:00:00'
and fssj<='2005-07-30 09:00:00'
提示我literal does not match fromat string 的错误,这个时为什么啊?????
sxr_szd,fx_dxzx,sx_dxzx from ls_dxx where bmlx=bmlx and dxfl=dxfl and dxlx=103 or
dxlx=203 or dxlx=201 and ydz_sd='2' or mddz_sd='3' and fssj>='2005-07-30 08:00:00'
and fssj<='2005-07-30 09:00:00'
提示我literal does not match fromat string 的错误,这个时为什么啊?????
解决方案 »
- 服务程序中怎么用timer?
- 如何delphi调用C#写的Web service中传递的DataTable 类型
- blazingfire 还有一个问题
- 为什么总是显示 invalid column name‘
- 问个数据库的问题
- 我想用C++写一个动态连结库,在Delphi下调用,可是我不太明白在C++写的Dll中的“Cout<<","Cin>>"怎么处理?
- 16:15 中国对0:2落后!!!!
- 请问在delphi中如何使现string到double的转换?答好给100分!
- 窗口的ONPAINT
- clientdataset如何排序?
- 大虾请进,怎么能在用UrlDownloadToFile下载东东时得到下载的进度?
- 怎样设置表中已存在的列为主键?
select * from aaa where BuyTime between '2005-01-01 14:20:30' And '2005-07-01 14:20:30'
如:
select * from aaa where BuyTime between '2005-01-01 14:20:30' And '2005-07-01 14:20:30'
select fssj,dxzx_id,fwq_ip,dx_xh,ydz,mddz,dxnr,dxlx,bmlx,dxfl,ydz_sd,mddz_sd,fxr_szd,
sxr_szd,fx_dxzx,sx_dxzx from ls_dxx where bmlx=bmlx and dxfl=dxfl and dxlx=103 or
dxlx=203 or dxlx=201 and ydz_sd='2' or mddz_sd='3' and (fssj>='07/30/2005 08:00:00'
and fssj<='07/30/2005 09:00:00')确保fssj为DATETIME型。
sxr_szd,fx_dxzx,sx_dxzx from ls_dxx where bmlx=bmlx and dxfl=dxfl and dxlx=103 or
dxlx=203 or dxlx=201 and ydz_sd='2' or mddz_sd='3' and
datediff(day, fssj, '2005-07-30')=0 and convert(varchar(8), fssj, 114)>='08:00:00'
and convert(varchar(8), fssj, 114)> <='09:00:00'
sxr_szd,fx_dxzx,sx_dxzx from ls_dxx where bmlx=bmlx and dxfl=dxfl and dxlx=103 or
dxlx=203 or dxlx=201 and ydz_sd='2' or mddz_sd='3' and fssj>=ToDate('2005-07-30 08:00:00','yyyy-mm-dd hh:mm:ss')
and fssj<=ToDate('2005-07-30 09:00:00', 'yyyy-mm-dd hh:mm:ss')
试一下!