select * from tablename where (datetime='01:00:00')var nowtime:datetime begin nowtime=Now; Query1.sql.text:='select * from tablename where table_col_time='+''''+datetostr(nowtime)+'''';
Query1.sql.text:='select * from tablename where table_col_time=#'+''''+datetostr(nowtime)+'#'+''''
#,在时间的两边都要加这个#号。你可以去看看access的帮助,有详细的说明。
用参数的方法最好!Sql.text:='select * from Tablename where Datetime=:DateTime';parambyname('DateTime').AsDateTime:=Now;
begin
nowtime=Now;
Query1.sql.text:='select * from tablename where table_col_time='+''''+datetostr(nowtime)+'''';