| 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: | |
| Category: | MySQL Server: Documentation | Severity: | S2 (Serious) |
| Version: | HEAD | OS: | irrelevant |
| Assigned to: | Dean Ellis | CPU Architecture: | Any |
[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.

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.