adoquery1.SQL.Text :='select count(* ) from d_dyxx where state='''+'0'+''''+' and DATEDIFF(year, csrq, getdate()) >= 25 and DATEDIFF(year, csrq, getdate())<35';
adoquery1.Open ;
在access里包错,应该怎么改!!
...全文
348打赏收藏
access日期跟sql server的区别!
adoquery1.SQL.Text :='select count(* ) from d_dyxx where state='''+'0'+''''+' and DATEDIFF(year, csrq, getdate()) >= 25 and DATEDIFF(year, csrq, getdate())<35'; adoquery1.Open ; 在access里包错,应该怎么改!!
格式化日期
var
Sbegindate,SEnddate :string;
Sbegindate :=FormatDateTime('yyyy-mm-dd',日期1)
SEnddate :=FormatDateTime('yyyy-mm-dd',日期2)
格式如下:
format('select * from d_dyxx where fielddate>=''%S'' and FieldDate<=''%s''',[Sbegindate,SEndDate]);