Bug #2152 missing feature availability info
Submitted: 18 Dec 2003 3:07 Modified: 18 Dec 2003 6:16
Reporter: [ name withheld ] Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Documentation Severity:S2 (Serious)
Version:HEAD OS:irrelevant
Assigned to: Dean Ellis CPU Architecture:Any

[18 Dec 2003 3:07] [ name withheld ]
Description:
I'm missing data on availability of certain functions:

mysql> SELECT DATE('2003-12-31 01:02:03');
ERROR 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '('2003-12-31 01:02:03')' at line 1

mysql> SELECT VERSION();
+------------+
| VERSION()  |
+------------+
| 4.0.15-log |
+------------+

How to repeat:
read the manual

Suggested fix:
ALWAYS say which version introduces respective feature.
[18 Dec 2003 6:16] Dean Ellis
We do this.

From the manual:

DATE(expr)
    Extracts the date part of the date or datetime expression expr.

mysql> SELECT DATE('2003-12-31 01:02:03');
        -> '2003-12-31'

    DATE() is available as of MySQL 4.1.1.

Thank you.
[18 Dec 2003 6:24] [ name withheld ]
well, what can I say... an acute case of blindnes, probably. sorry to waste your time.