searching for date only in datetime field

[Ralf Sander]

Hi Ruslan,

so, if I want to search for the  21/05/2004 it has to be:

	WHERE fld > '21/05/2004 00:00:00' AND fld < '22/05/2004 00:00:00'

?

Cheers,
Ralf



> 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
> -------------------------------------------------------------
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>