///高手请回答:SQL语句between 的用法?这样写对吗?给分!
close;
sql.clear;
sql.add('select * from dayrecord where jgno=:f and (year(rq)+''-''+month(rq)+''-''+day(rq)) BETWEEN :r1 and :r2 and pm=''0''');
Parameters.ParamByName('jmc').Value:=g_jgmc; //分支机构名称
Parameters.ParamByName('f').Value:=g_jgno; //分支机构代码
Parameters.ParamByName('r1').Value:=rq1; //
Parameters.ParamByName('r2').Value:=rq2; //
prepared;
execsql;
close;
sql.clear;
sql.add('select * from dayrecord where jgno=:f and (year(rq)+''-''+month(rq)+''-''+day(rq)) BETWEEN :r1 and :r2 and pm=''0''');
Parameters.ParamByName('jmc').Value:=g_jgmc; //分支机构名称
Parameters.ParamByName('f').Value:=g_jgno; //分支机构代码
Parameters.ParamByName('r1').Value:=rq1; //
Parameters.ParamByName('r2').Value:=rq2; //
prepared;
execsql;
sql.add('select * from dayrecord where jgno=:f and ''' + DataToStr(rq) + ''' BETWEEN :r1 and :r2 and pm=''0''');