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

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]

Reply via email to