对于日期的查找用什么好方法呢？(50分)

是这样的，用WIN32的日期控件获得日期，不要时间，然后与SQL SERVER的数据
库表的日期进行比较，但总是得不到数据
SQL语句是这样的：select * from dong where rq=:rq
parambyname('rq') := Dateyh.date
Open;

能不能这样写
select * from dong where rq>:qsrq and rq<:zzrq
parambyname('qsrq').asdatetime := strtodatetime(formatdatetime('yyyy-mm-dd',Dateyh.date)+' 0:00:00');
parambyname('zzrq').asdatetime := strtodatetime(formatdatetime('yyyy-mm-dd',Dateyh.date)+' 23:59:59');
Open;
我想应该没有问题,
知道你没有数据的原因吧!呵呵

我一般都是保存成yyyymmddhhmmss这种格式的，14c， 觉得字符处理起来方便点。

Returns one field from a date value.

EXTRACT(extract_field FROM column_reference)

Description

Use EXTRACT to return the year, month, or day field from a DATE or TIMESTAMP column.
If the column used with the EXTRACT function contains a NULL value, the return value of EXTRACT will be NULL.
If the value is not NULL, EXTRACT returns the value for the specified element in the date,
expressed as a SMALLINT.The Extract_Field parameter may contain any one of
the specifiers: YEAR, MONTH, DAY, HOUR, MINUTE, or SECOND. The specifiers YEAR,MONTH, and DAY can only
be used with DATE and TIMESTAMP columns. The specifiers HOUR, MINUTE, and SECOND can only
be used with TIMESTAMP and TIME columns.

多人接受答案了。