Hi,
My simple question is:
May i use grouping functions in the WHERE clause of a SQL query in mySQL?
For example, this failed to work:
SELECT date_field FROM tablename WHERE date_filed BETWEEN MIN(date_field)
AND MAX(date_field);
In the mySQL manual i red the following into "Functions to use in SELECT and
WHERE clauses/Comparision operators" section:
"If expr is a TIMESTAMP, DATE, or DATETIME column, MIN() and MAX() are
formatted to the same format if they are constants."
What this means?
may i use min()/max() into WHERE or not?
Pls help!
--
________________________________
Ventsyslav Vassilev
Comel Soft Multimedia
Sofia, Bulgaria
ICQ UIN: 11199819
e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
