On Wed 2003-03-05 at 17:12:23 -0600, [EMAIL PROTECTED] wrote:
[...]
> BA_DATE >= '2003-02-25 00:00:00' AND BA_DATE <= '2003-02-25 23:59:59'
>
> or
>
> TO_DAYS(FROM_DAYS(BA_DATE)) = '2003-02-25'
Hm. You mean FROM_DAYS(TO_DAYS(BA_DATE)), don't you? BA_DATE is a
timestamp, not a number of days.
Aside from that, it prevents use of indexes, which is always bad. :-)
How about
BA_DATE LIKE '2003-02-25%' instead?
HTH,
Benjamin.
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
