SQL Server:
SELECT * FROM TableName WHERE ColName BETWEEN CONVERT('YYYY-MM-DD','2002-05-01') AND CONVERT('YYYY-MM-DD 23:59:59','2002-05-30')ORACLE:
SELECT * FROM TableName WHERE To_Char(ColName,'YYYY-MM-DD') BETWEEN '2002-05-01' AND '2002-05-30'Access:
SELECT * FROM TableName WHERE Str(ColName) BETWEEN '2002-05-01' AND '2002-05-30 23:59:59'
SELECT * FROM TableName WHERE ColName BETWEEN CONVERT('YYYY-MM-DD','2002-05-01') AND CONVERT('YYYY-MM-DD 23:59:59','2002-05-30')ORACLE:
SELECT * FROM TableName WHERE To_Char(ColName,'YYYY-MM-DD') BETWEEN '2002-05-01' AND '2002-05-30'Access:
SELECT * FROM TableName WHERE Str(ColName) BETWEEN '2002-05-01' AND '2002-05-30 23:59:59'
with query1 do
begin
sql.clear;
sql.add('select * from table1 where date1>=:date1 and date1<=:date2');
parambyname('date1').asdatetime:=strtodatetime('2000-01-01');
parambyname('date2').asdatetime:=strtodatetime('2000-02-01');
open;
end;
SELECT * FROM TableName WHERE ColName BETWEEN CONVERT(DateTime,'2002-05-01') AND CONVERT(DateTime,'2002-05-30 23:59:59')
and strtodate('2002-05-30')
begin
sql.clear;
sql.add('select * from table1');
Sql.add('where date1>=:date1 and date1<=:date2');
parambyname('date1').asdatetime:=strtodatetime('2000-01-01');
parambyname('date2').asdatetime:=strtodatetime('2000-02-01');
open;
begin
sql.close;
sql.clear;
select * from m111 where (日期> :dd) and (日期<:dd1);
query1.Params[0].AsDateTime:=StrtoDateTime('2002-05-01');
query1.Params[1].AsDateTime:=StrtoDateTime('2002-05-30');
query1.Open;
end;如果还不行,建议不要使用中文字段。
begin
sql.clear;
sql.add('select * from table1 ');
sql.add('where convert(varchar(10),date1,120)>=:date1 ');
sql.add(' and convert(varchar(10),date1,120)>=:date2 ');
parambyname('date1').value := '2002-05-01';
parambyname('date2').value := '2002-05-30';
open;
begin
sql.clear;
sql.add('select * from table1 ');
sql.add('where convert(varchar(10),date1,120)>=:date1 ');
sql.add(' and convert(varchar(10),date1,120)>=:date2 ');
parambyname('date1').value := '2002-05-01';
parambyname('date2').value := '2002-05-30';
open;
sql.add(' and convert(varchar(10),date1,120)<=:date2 ');
希望大家以后多帮忙