如何查询日期时间型的字段?(100分)

C

caowei

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-05-25

• #1

ACCESS数据库,定义了一个DateTime类型的字段,名称为datetime.
查询时使用:
var
s: string;
....
s := DateTimeToStr(Date+Time);
query1.sql.add('select * from logdb where datetime>='+s);
...
出错. 使用query1.sql.add('select * from logdb where datetime>='+chr($27)+s+chr($27));
也不对.
应该如何进行查询啊??????????????

 

S

Sachow

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-05-25

• #2

Query1.sql.add('select * from logdb where datetime>= :ADate');
Query1.Params[0].AsDate := StrToDate(Edit1.Text);
Query1.Prepare;
Query1.Open;

 

A

agoo

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-05-25

• #3

...
query1.close;
Query1.sql.text := format('select * from logdb where str(datetime)>=''%s'' ',);
Query1.open;
...

 

W

WiseAnt

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-05-25

• #4

同意Sachow!

 

Z

zhhyan

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-05-25

• #5

用以下语句
var
s: string;
....
s := DateTimeToStr(Date+Time);
query1.sql.add('select * from logdb where datetime>=#'+s+'#');

 

C

caowei

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-05-30

• #6

接受答案了.