:is there a way to use the date part of a datetime field that
:still uses the
:index on the datetime field? i've tried a few different things
:and it keeps
:saying in the explain it says that its a possible_key, but
:NULL for the key
I'm not sure if this ignores the indexes or not, but I mostly use
DATE_FORMAT().
Assuming column "t" is a DATETIME column:
SELECT DATE_FORMAT(t, "%Y-%d-%m") FROM tbl_name;
Have you tried it yet?
Sherzod
--
mysql,sql
---------------------------------------------------------------------
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
