searching for date only in datetime field

[Ruslan Zasukhin]

On 2/16/05 1:08 AM, "Ralf Sander" <ralf at end-if.de> wrote:

Hi Ralf,

> How can I search for a date or date range ignoring the time in a
> datetime field?

This should work:

    WHERE fld > 'd/m/y 00:00:00'

Format of date according your current settings

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------