select * from tablename where convert(varchar(7),field,121)='2005-02'不知道在access中是否能通过
select * from tablename where year(date)=2005 and month(date)=2 sql2000中是这样写的,不知access行不行
select * from tablename where year(date)=2005 and month(date)=2
var d1,d2 :Tdate;begin d1:=strtodate('2005-02-01'); d2:=strtodate('2005-03-01');with adoquery do begin close; sql.clear; sql.add('select * form table where date>=:dd1 and date<:dd2'); parambyname('dd1').asdate:=d1; parambyname('dd2').asdate:=d2; open; end;不知道这样行不行!
sql2000中是这样写的,不知access行不行
d1,d2 :Tdate;begin
d1:=strtodate('2005-02-01');
d2:=strtodate('2005-03-01');with adoquery do
begin
close;
sql.clear;
sql.add('select * form table where date>=:dd1 and date<:dd2');
parambyname('dd1').asdate:=d1;
parambyname('dd2').asdate:=d2;
open;
end;不知道这样行不行!