Posted by Jay on 03/08/06 22:55

No problems ...

I have to use the DATETIME field, because that is what they have in place
already ...

Will try your code out - thanks!



"Codik" <marek.ham@gmail.com> wrote in message
news:1141824652.557343.194350@u72g2000cwu.googlegroups.com...
> Good day.
>
> I don't understand why You are using DATETIME field, when You want
> finding data only by date. My opion is. You create a DATE field and You
> use for 1. query:
> SELECT * FROM table WHERE date = '2006-01-01'
>
> And for 2. query:
> SELECT * FROM perform1 WHERE date >= '2006-01-01' AND date <=
> '2006-01-03'
>
> --
> When my English is bad, sorry.
>

[Back to original message]